Re: Using/Converting to UTF8 - PROBLEM SOLVED

[Theodosios Paschalidis]

Used 'ALTER TABLE table_name DEFAULT CHARACTER SET character_set_name;'

Had to reset my table auto_increment fields
'ALTER TABLE tablename AUTO_INCREMENT = XXX'

and set the server's default character set using
mysqld --default-character-set=utf8

Cheers

----- Original Message ----- 
From: "Theodosios Paschalidis" <theopa7@stripped>
To: <win32@stripped>
Sent: Thursday, January 15, 2004 5:56 PM
Subject: Using/Converting to UTF8


Hi all.

I have just upgraded from 3.23.52 to 4.1.1 in order enable UTF8 support for
Greek on a windows system.

I have restored by database and I am wondering how I should go about it.

1) Is there any easy way to convert everything (my tables contain both
english and greek fields)  to utf? is the "CONVERT()"  the only way to do
it? Can it be used for a whole database?

2) Would using "CHARACTER SET character_set_name | DEFAULT"  be a solution?
If yes how I can add the required mapping since I used the binary
distriburion and don't even have a "convert.cc" to edit.

3) If the answear to 2 is NO, how can I use utf from now on? (either on a
database or table level)

Any help would be most welcomed as I am new to all this.

Thank you for your time,
Theo