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