| 1 |
On Tuesday 05 May 2015 09:32:15 Joseph wrote: |
| 2 |
> I have my mysql database "Collation" set as: utf8_general_ci |
| 3 |
> |
| 4 |
> but when a customer from for example Japan places an order all I see is: |
| 5 |
> |
| 6 |
> 竹鼻立原町５& |
| 7 |
> ;#65293;５ |
| 8 |
> |
| 9 |
> Do I need to change "Collation" setting to something else or something else? |
| 10 |
|
| 11 |
I'm not sure which character codes are used for Japanese but it's worth noting |
| 12 |
that mysql's utf8 encoding is a partial implementation which only supports 3 |
| 13 |
bytes per character. |
| 14 |
|
| 15 |
For full utf8 support you'll need to use the utf8mb4 encoding. |
| 16 |
|
| 17 |
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb4.html |
| 18 |
https://mathiasbynens.be/notes/mysql-utf8mb4 |
| 19 |
|
| 20 |
Note that this is not relevant to your problem which is covered by |
| 21 |
Fernando Rodriguez' reply. |
Archives