Special chars
Posted: 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.
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.