« Gimp ile Web 2.0 Tarzı Etiket
Wordpress Temaları »

Mysql Tablo Karakter Seti Değiştirme

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

Tags:

This entry was posted on Saturday, July 28th, 2007 at 1:36 pm and is filed under Genel. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Mysql Tablo Karakter Seti Değiştirme”

  1. admin Says:
    July 28th, 2007 at 1:36 pm

    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;

Leave a Reply