How to force mySQL 4.1 default all table using utf8?

  • explorer1979
  • Graduate
  • Graduate
  • explorer1979
  • Posts: 109
  • Loc: Hong Kong SAR, China

Post 3+ Months Ago

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

Since my froum are using utf8, and it is a simpl. chinese forum, after I backup the forum by phpmyadmin by default setting, and try restore for test the backup, later my forum some chinese word will can't readable ....

thx

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

Post Information

  • Total Posts in this topic: 1 post
  • Users browsing this forum: No registered users and 40 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.