Line breaks in mysql and c# .net

[keiranvv]

Hi, I'm currently writing a c# application and I'm using a multiline textbox to save the address of a person. When the query is generated, the line breaks are shown as a "\r\n" escape sequence. However when the query is executed the lines breaks disappear. Any suggestions? Thanks a lot

[r035198x]

I don't understand this part of your description "When the query is generated, the line breaks are shown as a "\r\n" escape sequence. However when the query is executed the lines breaks disappear". When are the line breaks seen and when are they not seen?

[keiranvv]

for example: While I'm debugging the code, I can stop it after its created the query but before it executes it, so before it executes it looks like this "insert into tbl_example values(1, "test", "123 road\r\nsuburb" );" but after the statement is executed and I look at the database table, it shows that address as "123roadsuburb" . Hope that makes it clearer.

[r035198x]

What do you use to look in the database? What's the output of a select from that data like?

[keiranvv]

What do you use to look in the database? What's the output of a select from that data like?

I'm using navicat, and if i run a select statement on that data it comes out: "1, test, 123 roadsuburb"