Ömer Ücel

July 28, 2007

Mysql Tablo Karakter Seti Değiştirme

Filed under: Genel — Tags: — Ömer Ücel @ 1:36 pm

Bir proje için Drupal içerik yönetim sistemi ile uğraşıyordum. Türkçe karakterler kayıt sırasında sorun çıkartmazken görünümde bozulmalara sebebiyet veriyordu. Biraz araştırma ile bunun veritabanı, tablo ve hücre karakter setlerinden kaynaklandığını öğrendim. Ancak çok sayıda tablo olunca bunu -phpmyadmin ile- yapmanın epey süreceğini anladım bir kaç denemeden sonra. Ardından aşağıdaki kodları buldum.

Bir tablo içerisindeki tüm elemanların ve tablonun karakter setini değiştirmek için:

ALTER TABLE `tablo` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

sql kodunu kullanabilirsiniz(Ben utf8 e ayarlamaya çalıştım).

1 Comment »

  1. Fastastico ile Drupal 5.1 kurarsanız ve Türkçe karakter sorunu yaşarsanız yorulmayın. Emimin daha kısa bir yöntemi vardır :)

    ALTER TABLE `access` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `accesslog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `authmap` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `blocks` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `blocks_roles` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `boxes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `cache` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `cache_filter` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `cache_menu` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `cache_page` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `comments` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `files` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `file_revisions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `filters` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `filter_formats` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `flood` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `history` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `locales_meta` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `locales_source` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `locales_target` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `menu` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `node` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `node_access` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `node_comment_statistics` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `node_counter` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `node_revisions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `node_type` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `permission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `poll` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `poll_choices` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `poll_votes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `role` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `search_dataset` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `search_index` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `search_total` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `sequences` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `sessions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `system` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `term_data` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `term_hierarchy` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `term_node` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `term_relation` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `term_synonym` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `url_alias` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `users` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `users_roles` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `variable` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `vocabulary` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `vocabulary_node_types` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE `watchdog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

    Comment by admin — July 28, 2007 @ 1:36 pm

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress