csv导入mysql字符截断,从csv导入到mysql时保留特殊字符

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.

解决方案

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.