Tom Hughes wrote:
> You probably didn't make UTF-8 the default character set for the
> database when you created it.
>> Tom
>That sounds about right. The 0.5 schema script I downloaded which may
not be the latest contains a number of tables with "DEFAULT
CHARSET=latin1" defined.
As an FYI, a simple way to avoid all of these problems (at least I think
it does), is to add the following options to your /etc/my.cnf.
Under [mysql]
default-character-set=utf8
Under [mysqld]
default-character-set=utf8
I don't know what type of mysql setup debian has out of the box but on
fedora core 6 that was enough to make the "status" command in mysql show
the following lines:
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
Just be careful if you have any other apps on the same box that may be
impacted.
Cheers,
Brett