cancel
Showing results for 
Search instead for 
Did you mean: 

Error in bcp while migrating data from Sybase 12.5 to 15.7

0 Kudos

Hello,

While migrating data from server ASE 12.5 to ASE 15.7 i'm having serious difficulties to migrate data with special characters such es ñ ó é .

I can't use load database due to different logical pages sizes ASE12.5 2K ASE 15.7 8K)

To extract the data i'm using:

Source server ASE 12.7:

bcp DB..TABLE out /dir/TABLE.bcp -c -A2048 -Uuser -Ppasswd -Sserver

Destination Server ASE 15.7

bcp DB..TABLE in /dir/TABLE.bcp -c -Y -A2048 -Usa -Uuser -Ppasswd -Sserver

Starting copy... CTLIB Message: - L1/O2/S1/N42/1/0: blk_rowxfer(): blk layer: internal BLK-Library error: Data truncated while doing local character set conversion. col = 3 CTLIB Message: - L1/O2/S1/N42/1/0:

TABLE ddl:

URL_ID int

URL varchar(255)

DESCRIPTION varchar(255)

MODULO varchar(30)

Target field DESCRIPTION

in ASE 12.7

DESCRIPTION= Autenticación de usuario SAC

after bcp in ASE.15.7 it truncates all characters after ó

Result:

DESCRIPTION= Autenticaci

Thank you

Regards

Accepted Solutions (1)

Accepted Solutions (1)

former_member188958
Active Contributor
0 Kudos

Try adding the parameter '-Jiso_1' to both the bcp in and bcp out operations.

0 Kudos

Great it worked!

Thank you very much.

Answers (2)

Answers (2)

0 Kudos

Hello.

Are the servers configured for the same default character set? (sp_helpsort) - YES

ASE 12.5

sp_helpsort

Character Set = 1, iso_1 ISO 8859-1 (Latin-1) - Western European 8-bit character set.

Sort Order = 50, bin_iso_1 Binary ordering, for the ISO 8859/1 or Latin-1 character set ( iso_1).

ASE 15.7

sp_helpsort

Character Set = 1, iso_1 ISO 8859-1 (Latin-1) - Western European 8-bit character set.

Sort Order = 50, bin_iso_1 Binary ordering, for the ISO 8859/1 or Latin-1 character set ( iso_1).

Are you using the same bcp client for both the bcp out and the bcp in? - NO

They are different servers so i'm using each respective bcp

To extract data bcp out -> ASE12.5

to insert the data bcp in -> ASE 15.7

Thank you,

Regards

former_member188958
Active Contributor
0 Kudos

Are the servers configured for the same default character set? (sp_helpsort)

Are you using the same bcp client for both the bcp out and the bcp in?