MySQL Forums

I fix it using a not very good way.

Modify rw-splitting.lua

at function read_query
before line number 202
proxy.queries:append(1, packet)
add one line code
proxy.queries:append(2, string.char(proxy.COM_QUERY) .. "SET NAMES 'utf8'" )

restart you mysql-proxy

everything looks fine.

But this way is not very good, because it will call "SET NAMES 'utf8'" before every query, whatever need or not.

I want to just call "SET NAMES 'utf8'" one times while after mysql-proxy make a real MYSQL connection to backend-servers.

Wish anyone can fix this in better way.