I finally found the solution.
It's possible to set everything in MySQL ODBC/Connector on tab Connect
options. I had to write to the field Initial Statement statement SET NAMES
'wanted_character_set' and that solved the problem.
Dusan
----- Original Message -----
From: "Dušan Pavlica" <pavlica@stripped>
To: <mysql@stripped>
Sent: Thursday, February 24, 2005 9:53 AM
Subject: Re: Change default character_set_client, connection, results
> Gleb,
>
> thanks for your response, but that doesn't help me much because I'm using
> ADO components to connect to MySQL and not MySQL API functions.
>
> Regards,
> Dusan Pavlica
>
> ----- Original Message -----
> From: "Gleb Paharenko" <gleb.paharenko@stripped>
> To: <mysql@stripped>
> Sent: Wednesday, February 23, 2005 4:35 PM
> Subject: Re: Change default character_set_client, connection, results
>
>
>> Hello.
>>
>> Use MYSQL_SET_CHARSET_NAME option for mysql_options() function. See:
>>
>> http://dev.mysql.com/doc/mysql/en/mysql-options.html
>>
>>
>>
>>
>>
>> [snip]
>>
>> Hello,
>>
>> could someone tell me if it is possible to change default settings for
>> character_set_client, character_set_connection and character_set_results
>> variables? They
>> are always set to latin1 and I didn't find any way how to change their
>> default value.
>> I'm using MySQL 4.1.9-nt and MySQL ODBC 3.51. My applications are
>> written in C++ Builder
>> and I don't want to send command SET NAMES 'cp1250' whenever application
>> opens
>> connection.
>>
>> Thanks in advance
>>
>> [snip]
>>
>>
>>
>> --
>> 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
>>
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
