| 1 |
On 05/05/15 12:32, Fernando Rodriguez wrote: |
| 2 |
>On Tuesday, May 05, 2015 9:32:15 AM Joseph wrote: |
| 3 |
>> I have my mysql database "Collation" set as: utf8_general_ci |
| 4 |
>> |
| 5 |
>> but when a customer from for example Japan places an order all I see is: |
| 6 |
>> |
| 7 |
>> |
| 8 |
>竹鼻立原町５－５ |
| 9 |
>> |
| 10 |
>> Do I need to change "Collation" setting to something else or something else? |
| 11 |
>> |
| 12 |
>> |
| 13 |
> |
| 14 |
>I think that's because the web applications runs the data through something |
| 15 |
>like php's htmlspecialchars() or similar to help prevent SQL injections. So |
| 16 |
>you'll need to either decode it before using it (I think you can use the app- |
| 17 |
>text/recode), or use a different method to filter anything that could be |
| 18 |
>malicious SQL. |
| 19 |
|
| 20 |
I've saved the relevant information into a TXT file (address.txt) and tried to run: recode ISO-8859-9..UTF8 < address.txt > address2.txt |
| 21 |
|
| 22 |
&#31481;&#40763;&#31435;&#21407;&#30010;&#65301;&#65293;&#65301; |
| 23 |
&#23665;&#31185;&#21306; |
| 24 |
&#20140;&#37117;&#24066;, 601-8015 |
| 25 |
&#20140;&#37117;&#24220;, Japan |
| 26 |
|
| 27 |
It didn't help. How do you run "recode" correctly? |
| 28 |
Yes, the customer is using oscommerce php addlication to provide information. |
| 29 |
|
| 30 |
-- |
| 31 |
Joseph |
Archives