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.
Showing posts with label varchars. Show all posts
Showing posts with label varchars. Show all posts
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
YanaHi 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.
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
YanaHi 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.
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,
YanaHi 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.
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,
YanaHi 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.
Subscribe to:
Posts (Atom)