phpmyadmindeki Collation (karakter seti) ne olmalidir (cözüldü)

[velociraptor]

Forumum Türkce ve bu karakter setinin nasil ayarlanmasi gerektigi konusunda pek bir bilgim yok , sizler ne sekilde ayarladiniz=?
Birde her tablo icin bu set ayni mi olmak zorunda mesela bendekinde phpbb_search_wordmatch swedisc_latin_ci digerlerinde utf8_turkish , bunun bir sakincasi olurmu

[velociraptor]

SHOW CHARACTER SET ;
üstteki komut calistirilarak tüm karakterler bulunur
latin5 Türkce forumu olanlar icindir (latin5_turkish_ci) ve asagidaki komut calistirilir:

ALTER DATABASE `databank ismi` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
üstteki sorguda databank isminizi giriniz

Sonrasinda asagidaki komutlari tek tek calistiriniz (toplu bir yöntemi vardir ama simdilik bununla idare edelim)
ALTER TABLE `phpbb_auth_access` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_banlist` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_categories` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_config` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_confirm` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_disallow` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_forums` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_forum_prune` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_groups` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_posts` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_posts_text` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_privmsgs` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_privmsgs_text` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_ranks` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_search_results` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_search_wordlist` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_search_wordmatch` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_sessions` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_sessions_keys` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_smilies` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_themes` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_themes_name` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_topics` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_topics_watch` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_users` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_user_group` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_vote_desc` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_vote_results` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_vote_voters` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci
ALTER TABLE `phpbb_words` DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci



Kaynak:
http://dev.mysql.com/doc/refman/5.0/en/ ... mysql.html