RE: DBEXTRACT, DBLOAD for database created in UNICODE

Hi Norbert,


Norbert Popely [mailto:[email protected]] wrote:

> Subject: DBEXTRACT, DBLOAD for database created in UNICODE
> 
> 
> I have a poblem with DBEXTRACT and DBLOAD tables which contains a
> unicode characters. I all get: 
> 
> D:\Softs\Servers\SQL\SAP\depend\bin>repmcli -d DB0 -u ADM0,ADM0
> Loader Server Protocol File:   
> 'd:\softs\servers\sql\sap\indep_data\wrk\loader.prt'
> 
> User ADM0 connected to database DB0 on local host.
> 
> repmcli>DATAEXTRACT * FROM TABLE0 OUTFILE 'd:\coll.data' LONGFILE
> SQLINFO 'd:\sql.inf'
> 
> ERR -25350
> 
> Conversion from UNICODE data to ASCII data is not supported; this
> conversion may lose information
> 
> 
Simply append the encoding specifier to the data file specification in your
command as:

DATAEXTRACT * FROM TABLE0
 OUTFILE 'd:\coll.data' UCS2
 LONGFILE SQLINFO 'd:\sql.inf'

For LONGFILEs the loader checks the data type of the respective long
column and if the encoding spec is omitted for LONGFILE it takes
the one defined for this column. Thus if your long column is
created as LONG CHAR UNICODE (=LONG in pure UNICODE db) and the
above command is processed the long data is saved in UCS2.

Regards,
 Steffen
-- 
Steffen Schildberg
SAP DB Team
SAP Labs Berlin