MySQL Listers, Currently I am running MySQL 3.23, which I know is not really designed to handle utf-8. I am eagerly anticipating full utf-8 support in version 4.1. In the meantime, I am curious to know if there are any particular considerations I should take into account when storing utf-8 data in my current database which will make the transition to MySQL 4.1 as smooth as possible. I am new to databasing, and I have never upgraded a database before. In any case, my sites are hosted on a virtual server, where I have little control over the database settings. By reading the archives of this list and looking around on the net, I'm led to believe that it is possible to store utf-8 strings in TEXT columns, and that the only sacrifice is that sorting won't really work. Can I also store utf-8 strings in CHAR and VARCHAR columns? Up until now, I've been storing text as binary data. But in 4.1 it will be possible to designate different columns as different encoding sets. Will there be problems in going from a BLOB column to a utf-8 TEXT column? Will it be any better for me to store my current utf-8 data as TEXT columns and then in 4.1 assign encoding? Will that be possible? Any advice would be greatly appreciated. Thank you.
-- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]