MySQL Forums
Forum List  »  PHP

Advanced Search
New Topic

Re: Having tough time with spanish/catalan characters in my PHP/MySQL app
Posted by: Nico Abru
Date: February 10, 2009 08:31AM

You shuold have everithing configured to you char set an collation expample:
on /etc/mysql/my.cnf
add the following to set these vars:
[client]
default-character-set = cp1252

[mysqld]
skip-character-set-client-handshake
default-character-set = cp1252
character-set-server = cp1252
collation-server = latin1_general_cs
init-connect = SET NAMES cp1252

[mysqldump]
default-character-set = cp1252

[mysql]
default-character-set = cp1252

Restart server, and shoulf be done!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Having tough time with spanish/catalan characters in my PHP/MySQL app
Raj Tsevhar
February 08, 2009 07:10AM
Re: Having tough time with spanish/catalan characters in my PHP/MySQL app
Nico Abru
February 10, 2009 08:31AM


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.