Re: [gentoo-user] utf8_general_ci

[Fernando Rodriguez]

On Tuesday, May 05, 2015 9:32:15 AM Joseph wrote:
> I have my mysql database "Collation" set as: utf8_general_ci
>
> but when a customer from for example Japan places an order all I see is:
>
>
竹鼻立原町５－５
>
> Do I need to change "Collation" setting to something else or something else?
>
>

I think that's because the web applications runs the data through something 
like php's htmlspecialchars() or similar to help prevent SQL injections. So 
you'll need to either decode it before using it (I think you can use the app-
text/recode), or use a different method to filter anything that could be 
malicious SQL.



-- 
Fernando Rodriguez