Hi,

Luckily I already found the solution, may be it'll be usefull for someone else. All that was needed was adding the following line to my.cnf file:

[mysqld]
init-connect="SET NAMES koi8r"

Regards

----
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)718-3322, 718-3115(fax)

On Wed, 29 Jun 2005, Gleb Paharenko wrote:

Privet.

As I know, PHP usually takes the character set from the server.
Please send part of your configuration file related to character sets.


Varshavchick Alexander <[EMAIL PROTECTED]> wrote:
Hi,

I have mysql 4.1.12 started with the default charset 'koi8r' and I have
the following problem: when connecting from PHP, the default
results and connection charsets become latin1, so all not-latin characters
get lost (they are displayed as ?). Of cause, if I explicitely set these
charsets to koi8r in the PHP scripts after the mysql_connect statement, it
starts working correctly, but the problem is, there are so many php
scripts calling mysql_connect function that I cannot change them all.

I tried adding the default-character-set options into my.cnf in the
[mysql] section and it workso for mysql command line but not for the php.

So is there any way of setting the default connection charset which will
work from php? Or the only way is downgrading to mysql 4.0 to make the
existing php script work?

Regards

----
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)718-3322, 718-3115(fax)





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to