Andrey, thanks for your report!
You're right, There was a bug that the client library didn't
take in account --with-charset and --with-collation configure
attributes.
This bug was fixed in 4.1.3 which is going to be released soon.
A temporary solution with 4.1.2 is to use SET NAMES koi8r
after connection. Or run mysqld with --init-command=SET NAMES koi8r.
Regards.
Andrey Kotrekhov wrote:
SQL
Hi, All!
This is configure scrypt haw I have compiled mysql 4.1.2
./configure \
--prefix=/usr/local/mysql_4 \
--without-debug \
--with-charset=koi8r \
--with-collation=koi8r_general_ci \
--with-extra-charset=koi8u,cp1251 \
--with-mysqld-user=mysql \
--without-berkeley-db \
--without-isam \
--without-innodb \
--enable-thread-safe-client
After that any programs using libmysqlclient has the problem with
collation if they try compare char fields.
I try ask query show variables and see:
Variable_name=character_set_client Value=latin1
Variable_name=character_set_connection Value=latin1
Variable_name=character_set_databaseValue=koi8r
Variable_name=character_set_results Value=latin1
Variable_name=character_set_server Value=koi8r
Variable_name=character_set_system Value=utf8
Variable_name=character_sets_dir
Value=/usr/local/mysql_4/share/mysql/charsets/
Variable_name=collation_connection Value=latin1_swedish_ci
Variable_name=collation_databaseValue=koi8r_general_ci
Variable_name=collation_server Value=koi8r_general_ci
What options for configure should I set that my programs/clients have
character_set_client and etc is set to koi8r ?
Is this possible?
May be it is bug?
Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
. +380 562 34-00-4
4
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia
___/ www.mysql.com +7-912-856-80-21
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]