Sunday, March 11, 2012

export to text file problem

Hi,
I recognise that long varchars are cut when exported to the text file.
This is the scenario:
Define varchar(6000) in the test table. Put in one line with , for example, 600 chars.
Run import data to the text file. The length of the string in the text file is only 232 chars.
Any idea?
Thanks,
Yana
Hi Yana,
I tried creating the testtable and exporting the data to the text file.
Surprisingly it worked correctly.
I would be glad if you can furnish some more information, so that I will be
able to work on it more appropriately.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment