Mysql Tablo Karakter Seti Değiştirme

Posted Nisan 18, 2007
Filed under: Programlama, İnternet |

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).

Şu ana kadar 2 yorum

  1. Ömer Ücel on Nisan 18, 2007

    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;

    Yanıtla
  2. Murat on Ocak 8, 2008

    Supersiniz bu bilgiler cok isime yaradi.. :) ) bir tek drupal pathauto duzeltme isi kaldi

    Yanıtla

Leave a reply