MySQL table cells look blank, but contain CHAR(13)

[mrherman]

I imported a CSV which had some blank cells.  I tried to deal with the cells by using (for example)

 

WHERE myfield = '' or myfield = ' '

 

I couldn't get anything to work, so I copied the contents of one of the cells and pasted it in a text editor.  Come to find out, the cells contained CHAR(13) -- carriage returns.

 

How did carriage returns get into the cells of the CSV?  I generated the CSV from an EXCEL spreadsheet.

 

Thanks!

[PFMaBiSmAd]

Unless you had one long line in the file, each line had some kind of a new-line (cr/lf) on the end of it to cause the next line to be a separate line. Those new-line character(s) got inserted into your database unless you did something to remove them.

[mrherman]

Thanks for your reply.