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_database Value=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_database Value=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-44
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
