MySQL 4.1.0 UTF8 Support + Problem

[Vijay Dayafule]

I have read few documents available at www.mysql.com for setting the internationization at Server, Database, Table and Column level.

I want to set the whole Database server to support UTF8 character support.

On mysql.com site i found the below command to set UTF8 character set.

mysqld --with-charset=utf8

but it gave me an error message as:

mysqld: ERROR: unknown variable 'with-charset=utf8'

Then i tried with passing another command like:

mysqld --default-character-set=utf8

but it gave another error message as:

mysqld: Character set 'utf-8' is not a compiled character set and is not specified
in the 'C:\mysql\share\charsets\Index.xml' file

030610 17:34:38 Aborting

030610 17:34:38 mysqld: Shutdown Complete

and the utf8.xml file is not given with the 4.1.0 Alpha release...


Am i doing something wrong to set the encoding as utf8.

If any one knows how to set the server as UTF8 encoding character set, this will be a great help for me.

Post your answers ASAP.

Thank You,

[nicc777]

I have not played with this as yet, but I am also interested in this topic. Here is some interesting stuff I have found so far:

* Upgrading from MySQL 4.0

* Supported Charater Sets --> also check the sample SQL command to list these. I suggest you start mysqld without any parameters and run the command - see what glows

* Start-up Options for mysql --> Specifically look at the following: --character-sets-dir=... and --default-character-set=...

* MySQL Mailing List --> As I suspected, UTF support must be compiled in, so a default install might not have the support enabled. You should be able to test this with the SQL command mentioned above.

Well, hope this helps somewhat.

Cheers