I use the following script to fill my SQL Server 2008 Table.
create Table dbo.export_string_vals(
id int,
test_case varchar(100),
description varchar(100)
)
go
insert into export_string_vals select 1, 'this" continues
on the next line', 'embedded newline'
insert into export_string_vals select 2, 'this" continues' + CHAR(10) + 'on the next line', 'embedded newline'
insert into export_string_vals select 3, 'this" continues' + CHAR(13) + 'on the next line', 'embedded newline'
insert into export_string_vals select 4, 'this" continues' + CHAR(13) + CHAR(10) + 'on the next line', 'embedded newline'
go
When I view the table in Database Browser or export it to any format newline and carriage return characters are missing.
It is not possible to export data and reimport it and obtain the original data.
Edit:
I rechecked with 3.3.0.2 portable. In the grid the embedded characters are not visible, but copy and paste of a cell show, that they are present. Exports contain the line breaks, but not the exact bytes used to produce them.
The cases where export / import failed require more complicated test cases.
It would be a great improvement, if line breaks could be visualized in the grid representation.
