CODEWITHSUNDEEP
mysqlcsvcharacter-encoding
pdizz
pdizz

Reputation: 4240

Getting strange results from MySQL table imported from CSV file. Encoding issue?

I imported a table from a CSV file into MySQL using this query:

LOAD DATA LOCAL INFILE 'C:/wamp/www/Alchemy/effects.csv'
INTO TABLE effects
FIELDS TERMINATED BY '\n'
(eff_name);

The import seemed to work fine and the table appears correct in phpmyadmin but when I try to SELECT * WHERE eff_name="whatever"; I'm getting no results. When I try SELECT * FROM effects; from the command line (windows) I get this strange output: https://i.sstatic.net/ltjm1.jpg

I'm able to select by name in all my other tables it's just this table that is giving me problems. It is also the only table imported from CSV. As I said, it appears normal in phpmyadmin. Is this a character encoding issue? Did I import wrong? What can I do to fix this? I tried converting the CSV file to utf-8 and ansi in notepad++ and I'm still having issues. I'm at a loss.

Upvotes: 1

Views: 292

Answers (1)

schtever
schtever

Reputation: 3250

Try LINES TERMINATED BY '\r\n'.

Upvotes: 2

Related Questions