CODEWITHSUNDEEP
mysqlcsvphpmyadmin
user3293128
user3293128

Reputation: 15

Using UTF-8 encoding, CSV file with special properties/foreign characters not preserved when imported into MySQL (phpMyAdmin)

My table needs to support pretty much all characters (Japanese, Danish, Russian, etc.)

However, while saving the 2-columned table as CSV from Excel with UTF-8 encoding, then importing it with phpMyAdmin with UTF-8 encoding selected, a lot of the original characters go missing (the ones with special properties such as umlauts, accents, etc.) Also, anything following problematic characters is removed entirely. I haven't the slightest idea what is causing this problem.

EDIT: For those that come upon the same issue, I'd suggest opening your CSV file in Notepad++ and going to "Encoding > Convert to UTF-8" (not "Encode in UTF-8") first. Then import it. It will surely work.

Upvotes: 1

Views: 4166

Answers (1)

user3416209
user3416209

Reputation: 11

I found an answer here: https://help.salesforce.com/apex/HTViewSolution?id=000003837

Bascially save as a unicode text file from excel, then replace all tabs with commas in code friendly text editor, re-save as utf8 change file from .txt to .csv

exporting directly from excel to .csv causes problems with Japanese, this is why I went searching for help...

Upvotes: 1

Related Questions