Entry

Can I use multiple character sets in MySQL simultaneously?

May 18th, 2000 20:30
Nathan Wallace, Tim Smith, Benjamin Pflugmann

MySQL supports several charsets (big5, gbk, ujis, sjis cp1215 all might
be interesting to you).  But only one charset can be used in any one
mysqld (you specify the charset when you start the server, with version
3.23).  If you need to use more than one charset at a time, you'll need
to run more than one instance of mysqld, using separate datadir
directories.

Obviously, this is less than ideal.  We're planning to add support for
many charsets within one database (down to the column level), but it's
not being developed at the moment.

You might like to read up at:

    http://www.mysql.com/Manual_chapter/manual_Server.html#Languages