Hello.
> That is my my.ini snip (my.ini is located in MySQL base dir - is that > correct?): On Windows, MySQL programs read startup options from the following files: WINDIR\my.ini C:\my.cnf Use --defaults-file=/path/ command line option to specify the exact location of my.ini file. > Here is some more light on my problem: I am trying to set up default > connection codepage for PHP scripts. I've look through source code of mysql extention of php, and hadn't found any php-side part of code where it was set client character set. It takes place at the libmysqlclient side. And in most cases it takes the server's character set (I've analyze behavior of scripts and source code of libmysqlclient). I think it is no way to specify the client character set in php script, except using SQL statements or mysql_options(). "Denis Gerasimov" <[EMAIL PROTECTED]> wrote: > > Hello, > >> -----Original Message----- >> From: Gleb Paharenko [mailto:[EMAIL PROTECTED] >> Sent: Tuesday, December 21, 2004 1:29 PM >> To: [EMAIL PROTECTED] >> Subject: Re: Default connection codepage >> >> Hello. >> >> Put default_character_set='blah123' in your [client] and [mysql] >> sections of your config file. > > That is my my.ini snip (my.ini is located in MySQL base dir - is that > correct?): > > [client] > > # what you suggested, seems to have no effect in my case > default-character-set=cp1251 > port=3306 > > [mysqld] > port=3306 > basedir=C:/Program Files/MySQL/MySQL Server 4.1/ > datadir=E:/intranet/dbdata/ > default-character-set=cp1251 > default-storage-engine=INNODB > > ... > > Here is what I have now > > mysql> status > -------------- > mysql Ver 14.7 Distrib 4.1.7, for Win95/Win98 (i32) > > Connection id: 1 > Current database: > Current user: [EMAIL PROTECTED] > SSL: Not in use > Using delimiter: ; > Server version: 4.1.7-nt > Protocol version: 10 > Connection: localhost via TCP/IP > Server characterset: latin1 > Db characterset: cp1251 > Client characterset: cp1251 > Conn. characterset: latin1 > TCP port: 3306 > Uptime: 4 sec > > Threads: 1 Questions: 3 Slow queries: 0 Opens: 11 Flush tables: 1 Open > tables: 0 Queries per second avg: 0.750 > -------------- > > Service installed as "C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt" > --defaults-file="C:\Program Files\MySQL\MySQL Server 4.1\my.ini" MySQL > > default-character-set setting in [client] section has no effect (at least in > mysql utility and PHP) > > Here is some more light on my problem: I am trying to set up default > connection codepage for PHP scripts. > > Configuration I use: > MySQL 4.1.7 > PHP 5.0.2 > PEAR's DB + DB_DataObject (both latest) > > Does anybody have the same problem? > >> >> "Denis Gerasimov" <[EMAIL PROTECTED]> wrote: >> > >> > Hello, >> > >> > Is there any way to change default MySQL _connection_ codepage? >> > (e.g. by ini/cnf files setting, by startup parameters or some other way) >> > >> > Please, do not suggest running >> > >> > SET CHARACTER SET blah123 >> > >> > Thanks. >> > >> > Best regards, Denis Gerasimov >> > Outsourcing Services Manager, >> > VEKOS, Ltd. >> > www.vekos.ru >> > >> > >> > >> > >> >> >> -- >> 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] > > Best regards, Denis Gerasimov > Outsourcing Services Manager, > VEKOS, Ltd. > www.vekos.ru > > -- 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]
