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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
