Hello.
Use set NAMES 'utf8'; to set the connection character sets to the corresponding values. See: http://dev.mysql.com/doc/mysql/en/charset-connection.html Rob Cochrane <[EMAIL PROTECTED]> wrote: > Hi Gleb, > > Ok here is the command line info which also answers the version question. > Enter password: ********** > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 1 to server version: 4.1.9-nt > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> show variables like '%char%'; > +--------------------------+--------------------+ > | Variable_name | Value | > +--------------------------+--------------------+ > | character_set_client | latin1 | > | character_set_connection | latin1 | > | character_set_database | utf8 | > | character_set_results | latin1 | > | character_set_server | utf8 | > | character_set_system | utf8 | > | character_sets_dir | C:\share\charsets/ | > +--------------------------+--------------------+ > 7 rows in set (0.72 sec) > > mysql> > I am downloading v.10 right now. I believed we were using .10 but in > verifying I have found not. I will re-test when the upgrade is installed. > > Many thanks > > Rob > > Gleb Paharenko wrote: > >> >> At first, we should check that there is nothing wrong with the >> character_set_xxx variables. Please send us the output of the >> following statement: >> >> show variables like '%char%'; >> >> Does the problem remain if you are making the query using a mysql >> command line client? Do you use the latest release (4.1.10 now)? >> >> >> > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
