CODEWITHSUNDEEP
databasecsvutf-8phpmyadmin
Unis Da
Unis Da

Reputation: 33

imported Csv not utf 8 in Phpmyadmin

I imported a .csv file with utf-8 to my phpmyadmin.

I set the Character encoding of the file to 

utf-8,

the seperator to 

;

and the rest to default.

The import worked successfully, but then I switched to the view of the "created database" and saw that all (German) Accents like:

Ü, Ö, Ä, ß..

Are replaced with

?

I guess something with the phpmyadmin unicode is wrong,

because my imported csv can show those accents.

Does anyone how a few tips or a solution?

EDIT:

I looked through the my.ini to check for the default character settings, but they seem to be fine.

#collation_server=utf8_unicode_ci
#character_set_server=utf8

The Structur (next to view) in phpmyadmin also shows

utf8_general_ci

Upvotes: 0

Views: 2996

Answers (1)

Faraz Younis
Faraz Younis

Reputation: 31

Importing a CSV file with special characters require the file be saved in a UTF-8 format. Please follow the steps below

  1. Open the CSV file using text editor like Notepad(recommended).
  2. Click File > Save As, enter a file name and change the encoding to UTF-8. Then click the Save button.

Now, import the file again and all the special characters should be properly imported.

Upvotes: 1

Related Questions