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" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
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" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
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 / /|_/ / // /\ \/ /_/ / /__ [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]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
