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]

Reply via email to