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


Best Regards,
Jimmy Chan
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

Post Information

  • Total Posts in this topic: 1 post
  • Users browsing this forum: No registered users and 70 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.