On Mon, Oct 22, 2012 at 10:19 AM, Vincent de Lau <[email protected]> wrote:
> This should indeed be the proper approach. As long as the data in the
> tables
> is encoded properly, MySQL can and will convert the data back and forth
> depending on the session character set. I'm not sure how a UTF-8 to Latin1
> mismatch will be handled though.
>
Note: Mysql cannot do any "smart" transliteration, so beyond-ascii
characters from
UTF-8 will be converted to "?" (question marks).
Example:
mysql> SELECT CONVERT(_utf8'zażółć' USING latin1);
+-----------------------------------------+
| CONVERT(_utf8'zażółć' USING latin1) |
+-----------------------------------------+
| za?ó?? |
+-----------------------------------------+
1 row in set (0.00 sec)
--
__
/.)\ +48 695 600 936
\(./ [email protected]
