Discussion Locked

How mySQL 4.1 default using utf8?

0 helpful

1 reply

by jimmy chan 1979 Oct 26, 2005 last reply Dec 13, 2005

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

then rebuild the site db, and mysql should use utf-8 instead of latin1 [ iso8859-1 ]

if that doesn't work, reinstall, and select uft-8 as the install charset system, that should build everything as utf-8.

This discussion is closed to new replies.