Conversation

Notices

1. Hojjat Ali Mohammadi Evan Prodromou

   Do you removed #persian support from #identi.ca ? @evan #farsi #font http://ur1.ca/93xi4

   
   about a year ago from web
   • Evan Prodromou

     I've started using mysql-proxy and it wasn't handling non-latin character sets right. I think it's fixed now, though.

     about a year ago
   • Jacques Marneweck Evan Prodromou

     Was that an issue with php and solaris locales?

     about a year ago
   • Evan Prodromou Jacques Marneweck

     No. It was that the servers had latin1 as the default; our code uses 'SET NAMES "utf8"' on connect, but mysql-proxy doesn't pass thru to ro

     about a year ago
   • Evan Prodromou Evan Prodromou , Jacques Marneweck

     ...read-only servers when it's load-balancing. @jacques

     about a year ago
   • Evan Prodromou Evan Prodromou

     I fixed the problem (I think) by setting utf8 as the default char set for all the servers.

     about a year ago
   • Jacques Marneweck Evan Prodromou

     Typically you ensure the following is set under the [mysqld] section in your /opt/local/etc/my.cnf: default-character-set=utf8

     about a year ago
   • Jacques Marneweck Evan Prodromou

     default-collation=utf8_general_ci character-set-server=utf8 collation-server=utf8_general_ci init-connect='SET NAMES utf8'

     about a year ago
   • Jacques Marneweck Evan Prodromou

     Apologies that this is posted over two replies. mysql proxy transparently redir q's so that the new connection is not aware of the charset.

     about a year ago