[eluser]Ducky[/eluser]
Hi,
I'm trying to import a CSV file into a Mysql database. To do this i created a controller who reads the CSV file, and i use the following command
Code:
$this->db->set('name', $name);
to add it to the SQL statement.
Everything goes fine until a certain point. Then suddenly the text from field A is partial imported and the second half is imported 2 fields further (Field C). the text didn't split on a space but in the middle of the word "installation".
When this occurs the import will continue but the content isn't of the fields don't match anymore.
When i change the text manually it works fine but then many records further the same problem exists with another record.
You could say change everything manually and then import it. The problem with this method is that the csv will be provided to my application once an hour so it is impossible to do this manually every time
I don't believe it has something to do with UTF-8 because i'm using the active record method which escapes the values.
Can someone help me with this?
Kind regards
ducky