On Tue, 20 Apr 2004 11:32:22 +0300, Victoria Reznichenko wrote: > Stormblade <[EMAIL PROTECTED]> wrote: >> Hopefully this will be the last snag...least till the next one :) >> >> I'm having a problem setting the charset to unicode (utf-8). If I >> understood what I read I can set each table to support a charset. But what >> I want to do is set the default charset for a database to be utf-8. Is this >> possible? If so how? > > Yes, it's possible from version 4.1.0. > > CREATE DATABASE db_name DEFAULT CHARACTER SET utf8; > > http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html
Oh boy, that will be a pain. I use a GUI (Navicat and EMS MySQL Manager) and so far have not seen a way for me to make it create a table with a default character set. Nor even change it. Well at least I know it's possible. Thanks. >> >> In any case, I need to be able to store unicode data and retrieve it. > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming exp.) My System: http://www.anandtech.com/mysystemrig.html?rigid=1683 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]