On Tuesday 05 May 2015 09:32:15 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: > > 竹鼻立原町５& > ;#65293;５ > > Do I need to change "Collation" setting to something else or something else?
I'm not sure which character codes are used for Japanese but it's worth noting that mysql's utf8 encoding is a partial implementation which only supports 3 bytes per character. For full utf8 support you'll need to use the utf8mb4 encoding. https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb4.html https://mathiasbynens.be/notes/mysql-utf8mb4 Note that this is not relevant to your problem which is covered by Fernando Rodriguez' reply.
