04-03-2017 11:31 AM - edited 02-03-2024 9:28 PM
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
Try adding the parameter '-Jiso_1' to both the bcp in and bcp out operations.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.