distal-attribute
distal-attribute
distal-attribute
distal-attribute

converting \n\r\t at sql import ?

robsteinde posted 8 years ago in Import/Export
Hi,

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 8 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 8 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:
(origin)
parameter1=value parameter2=value
class=something
(corrupt)
paramter1=value\nparameter2=value\rclass=something

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