Mysql-Proxy + PHP 5.2 and UTF-8

Asked by aeroox on 2010-11-30

Hi All,

I have a problem with encoding using mysql-proxy:
 When I connect php (5.2.14) to the mysql server directly (Master and on each slave on port 3306) everything works fine but when I connect to mysql-proxy (port 4040) I have a problem with accents. I have checked my mysql configuration on Master & Slaves and they are in utf-8.

Here is the configuration of my master and 3 slaves:

[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
default-character-set=utf8

[mysqld]

default-character-set=utf8
default-collation=utf8_general_ci
character-set-server=utf8
collation-server=utf8_general_ci

Many people are experiencing the same problem : http://forums.mysql.com/read.php?146,198892,198892

I tryied everything without success ????!!!!!!!

Any ideas ?

Question information

Language:
English Edit question
Status:
Answered
For:
MySQL Proxy Edit question
Assignee:
No assignee Edit question
Last query:
2010-11-30
Last reply:
2010-11-30
Jan Kneschke (jan-kneschke) said : #1

Problem is that the connection state is not tracked for all possible cases in the rw-splititng script.

We documented them in http://forge.mysql.com/wiki/MySQL_Proxy_RW_Splitting

Keep in mind that RW-Splitting is a Proof of Concept only. Please see the wiki page for more information.

Can you help with this problem?

Provide an answer of your own, or ask aeroox for more information if necessary.

To post a message you must log in.