Keep special characters when importing into mysql from csv

Question

I have a csv file which contains special characters. However, when I import them into my table they do not import. I have the row that needs to contain special characters setup as utf8_general_ci

However, I am losing the special characters upon phpmyadmin import. For example, the degree symbol is not importing. I viewed my csv file in a text editor and it does contain the special characters.

Please help.

Ok, I figured how to do this. See my answer below.

Answer 1

Only needs change the charset in mysql when try to upload the file. In my case works the charset windows-1252

Answer 2

Ok,

for anyone who has this same issue trying to keep the exported csv file in utf8 while keeping the special characters do the following.

Open up your file in OpenOffice Calc. When you get ready to save it save it as text csv file. While exporting it will ask you what format to save it as. Save it as UTF8 and presto. It does not convert your special characters like excel does.

Hope that helps someone else.