Hello.
I also have a problems with MySQL Control Center, though it isn't
supported now, and another client, MySQL-Front. But the latest
MySQL Query Browser works perfectly with... Check
your queries with MySQL Query Browser 1.1.5, you can download it
from:
http://dev.mysql.com/downloads/query-browser/1.1.html
Another approach to use utf8 character is to write the queries
into the file, and then use a command 'source' of the mysql command line
client:
mysql> source file.sql
Don't forget to set NAMES 'utf8' in every client that you use.
Rob Cochrane <rob@stripped> wrote:
> Hello Gleb,
>
> Below is an extract of the SQLyog history on startup
> /*[02:26:25 PM][ 0 ms]*/ show variables like '%character%'
> /*[02:26:25 PM][ 0 ms]*/ Set character_set_connection=utf8
> /*[02:26:25 PM][ 0 ms]*/ Set character_set_results=utf8
> /*[02:26:25 PM][ 0 ms]*/ Set character_set_client=utf8
> /*[02:26:25 PM][ 0 ms]*/ show databases
>
> I then tested again without any change this even shows up in a varchar
> field where I am trying to put in the Afrikaans word visu?le (first e
> alt 0235) and it truncates before the e so I get visu and then nothing.
> show variables like '%char%'; reports as follows:-
>
> mysql> show variables like '%char%';
> +--------------------------+--------------------+
> | Variable_name | Value |
> +--------------------------+--------------------+
> | character_set_client | utf8 |
> | character_set_connection | utf8 |
> | character_set_database | utf8 |
> | character_set_results | utf8 |
> | character_set_server | utf8 |
> | character_set_system | utf8 |
> | character_sets_dir | C:\share\charsets/ |
> +--------------------------+--------------------+
> 7 rows in set (0.01 sec)
>
> mysql>
> Yet the data is still lost.
>
> I do appologise for taking so much of your time but this is becomming
> highly frustrating as the site I am building is English Afrikaans German
> and Spanish and I call all data for that language based on the language
> chosen by the user or default to the language I detect from a lookup of
> his IP address.
>
> Many thanks
>
> Rob
>
>
> Gleb Paharenko wrote:
>
>>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 <rob@stripped> 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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
