On 12/20/06, Jonathan Ben Avraham <[EMAIL PROTECTED]> wrote:
ISO-8859-1 -> UTF-8 is a trivial conversion, just move the data.
This is only true if your data is Latin-only. Otherwise, this will result in data corruption. In any case, with MySQL 4 and higher, you should update the table scheme accordingly so MySQL will know what character set it really stores, so "just moving the data" isn't the only thing you need to do. In my (5.0) MySQL, I see the ALTER TABLE CONVERT TO CHARACTER SET command. You should look into that in the MySQL manual. ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
