I have a .txt file and I want to import the content of the file into MySQL. When I double click the file I see all fields looks fine. There's a field called dogum_ili which supposed to be tiny int 2.
But when I try to import the text file MySQL gives an error message telling that the field can't be int as there are some chars on the source file.
I made the field change to char and imported the file and with HeidiSQL I don't see any strange chars on the field. When I send a query with load into file command to export a text file, I see some \ chars on the text.