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]