converting \n\r\t at sql import ?

robsteinde posted 10 years ago in Import/Export

at every export breaks, tabs and spaces were converted to \r, \t and \n - ok.
But when I execute these sql-queries for an import the \r, \t and \n still stay in the textfields, so that the text output of my cms is bad.
What should I do ?
ansgar posted 10 years ago
That's odd and should not be true.

Me seems that you're using an old HeidiSQL version. Please verify you're using the latest 3.0 final from http://www.heidisql.com/download.php .

If not so: please provide some detailed information:
- Used HeidiSQL for export AND import ?
- Some sample data which was corrupted by HeidiSQL (1. before corruption, 2. after corruption)
robsteinde posted 10 years ago
It's 3.0 final.
I used HeidiSQL for both.

I did some tests and got the result, that it depends on the mysql version which is selected for export. For 3.x and 4.0 the error occurs, for 5.1 everything's fine.
So, for me it's no longer a problem, I can use 5.1.

example data:
parameter1=value parameter2=value

Please login to leave a reply, or register at first.