Error in bcp

Some of your data is long and has been truncated, probably at 256
characters. Your rows are in the table but some columns will have been
chopped.

Are you using native or character format? What version of the client
library? What version of ASE? Any text/image columns? Any long char
columns?

--ian

R Garces wrote:
> I execute a bcp out , truncate the table and then a bcp in
> on a table and this message appear:
>
> CSLIB Message: - L0/O0/S0/N36/1/0:
> cs_convert: cslib user api layer: common library error: The
> result is truncated because the conversion/operation
> resulted in overflow.
> CSLIB Message: - L0/O0/S0/N24/1/0:
> cs_convert: cslib user api layer: common library error: The
> conversion/operation was stopped due to a syntax error in
> the source field.
> CSLIB Message: - L0/O0/S0/N24/1/0:
> cs_convert: cslib user api layer: common library error: The
> conversion/operation was stopped due to a syntax error in
> the source field.
> Batch successfully bulk-copied to SQL Server.
>
>
> I count the number of lines and it's OK. What means this
> error ?
>
> Thanks !

If your table has text columns you must use the -T option if any of the text
fields are greater then 32767 characters

wrote in message news:421f36c8.7d4e.1681692777@sybase.com...
>I execute a bcp out , truncate the table and then a bcp in
> on a table and this message appear:
>
> CSLIB Message: - L0/O0/S0/N36/1/0:
> cs_convert: cslib user api layer: common library error: The
> result is truncated because the conversion/operation
> resulted in overflow.
> CSLIB Message: - L0/O0/S0/N24/1/0:
> cs_convert: cslib user api layer: common library error: The
> conversion/operation was stopped due to a syntax error in
> the source field.
> CSLIB Message: - L0/O0/S0/N24/1/0:
> cs_convert: cslib user api layer: common library error: The
> conversion/operation was stopped due to a syntax error in
> the source field.
> Batch successfully bulk-copied to SQL Server.
>
>
> I count the number of lines and it's OK. What means this
> error ?
>
> Thanks !

Hi,

I got the same error and the mistake was in the bcp out, because the source server was in utf8 and the option -J was iso_1, just take care in the server codification and try again.

Originally Posted by isaacfi@

Hi,

I got the same error and the mistake was in the bcp out, because the source server was in utf8 and the option -J was iso_1, just take care in the server codification and try again.

How do you check the source server is in utf8. Can you please help me in this.. I am facing serious issue related to this error.
$SYBASE/$SYBASE_OCS/bin/bcp PostVenta.dbo.TPPA_TPV_PAYMENT in "WAMAP_MS_data/TPV_PAYMENT_VIEW_FIRST.dat" -S INET5P_MS -U spaadm -P airtel001 -I cfg/sybaseInterfaces.cfg -n -J iso_1 -b 10000
Starting copy...
CSLIB Message: - L0/O0/S0/N20/1/0:
cs_convert: cslib user api layer: common library error: The conversion/operation resulted in overflow.


Above is the problem, i am getting.