[問]How to force Debian 3.1's mySQL 4.1 using utf8-general-ci charset for all table and databse

用戶登入

活躍的討論版主題

新的討論版主題

誰在線

當前有 1 位註冊使用者 和 6 位訪客 在線。

歡迎新會員

大卫
avon
skyting
onewordpress
Constant

[問]How to force Debian 3.1's mySQL 4.1 using utf8-general-ci charset for all table and databse

2005, 十月 26 - 22:37 — explorer1979

Hi all,

after install the mysql 4.1 on Debian 3.1, later I donwloaded the SMF (SimpleMachine.org) forum and success installed it ...

But when I using phpmyadmin login to mysql localhost ..., see all table are using MyISAM and the charset are all lanti

I want to force mysql all using utf8_general_ci, since my forum and all other application base on myssql are for Chinese ... utf8 for me is useful!

Can anyone teach me how to build a database and table that all support utf8_general_ci

thx

Best Regards,
Jimmy Chan
http://www.wusogorphoto.net

發表評論

2005, 十一月 9 - 12:38 — 訪客

seem the charset will not giv

seem the charset will not give u any troble in this case . any how . u can 'show variables' to check it out , and change the varialbe include the charset to what u ever want , also , u can use alter table to modify the create table rulese . in this case , i think the forum just create the tables with the latin , but wont give u any trouble in chinese font storage .