If I POST a string, say "configuración", to a MySql Data Base using UTF-8 charset, how should it look if I explore the data using PHPmyAdmin.
Like this
1.- configuración
or this
2.- configuración
I am trying to determine this to see if I am using the charset right.
If in my database the string is represented in the second form, in a HTML Table it is echoed in a readeable way (configuración). But when I export as .csv using PHP, Excel for Mac opens it in a non readeable way (configuraci?n).
And if in the database is displayed in the first form, in the HTML is represented in a non readable way, but on the .csv export it is displayed as readable text.
Asked
Active
Viewed 21 times
0
Mauricio Mercado
- 1
- 1
-
@manniL how is that? – Mauricio Mercado Oct 16 '16 at 18:13
-
You can use utf8mb4 value for the table – samayo Oct 16 '16 at 18:28
-
Duplicate of "Trouble..."; see in particular 'Test the Data' and 'Mojibake'. Finally look at 'Fixes' for solutions. – Rick James Oct 17 '16 at 19:21