Special chars

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
antonio
Posts: 6
Joined: Fri 13 Oct 2017 04:51

Special chars

Post by antonio » Mon 13 Nov 2017 07:35

Hello!
When i copy two some rows from query result to Excel - in fact inserted 3 rows (blank row between)
I think this happing because last field of first row contents special chars CHAR(13) + CHAR(10)
When i copy same rows from SSMS - blanc rows do not adds (inserting only 2 rows).
How i can copy from DBForge like from SSMS?

upd.(field type VARCHAR(255))
upd2. empirically only CHAR(13) in the last position in field insert new line in Excel.

Sorry for my english.

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: Special chars

Post by .jp » Tue 21 Nov 2017 08:21

Hello,

Thanks for the post.
Could you please tell us what product you are using and its version.

Best Regards.

Post Reply