CSV Import chppes characters

asked Dec 30, 2013 in Database by MirrorXYZ (1,400 points)
Hi all
My CSV import sheets data has strange characters chopped Off . I am looking for a way I can set my server to accept single quotes, quotations, trademark ,  and other symbols as they originally are without needing the symbols HTML version .
Can anyone please help?
Thank you

1 Answer

0 like 0 dislike
answered Dec 30, 2013 by validnet (1,140 points)
Make sure your database encoding is configured with the character set used in your CSV file. This might help http://dev.mysql.com/doc/refman/5.5/en/charset.html