Re: Cyrillic characters in Mysql 3.23.55
Posted by: Shuichi Tamagawa
Date: June 02, 2005 10:34PM

> Now Mysql 4.1.12 is up and running. I have been
> changing tables to utf8 and all that sort of
> things. I think that this side of the matter is OK
> now.

Good.

One thing. Unless you compiled MySQL from source using --with-charset=utf8 option and configured PHP to use that client library, the character set of the client library used by PHP is latin1. The configuration in my.cnf doesn't matter because it works only for mysqld and mysql client programs in bin direcotry. So, you need to make sure that the client character set, when the PHP program connect to MySQL server, is set to utf8. The way to do this without re-compiling MySQL is to set a server variable in [mysqld] section of my.ini file as follows.

init_connect='SET NAMES utf8'

For init_connect variable, see http://dev.mysql.com/doc/mysql/en/server-system-variables.html.

If you are going to administer this server, it is highly recommended to read the following page of the manual and clearly understand how the character sets work in MySQL 4.1.

http://dev.mysql.com/doc/mysql/en/charset.html

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Cyrillic characters in Mysql 3.23.55
2402
June 02, 2005 10:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.