 Unload with dbspace definition / charset -
07-17-2008
, 02:26 AM
Hi
asa 9.02
which way can i unload structure with dbspace definition for
tables?
dbunload produced reload script for one dbspace.
are any changes in encoding between 9.02 and 10.x?
have a working asa 9.02 with utf8 charset.
unload/reload for same version works ok. if i try to load
data
in asa 10.0.1, created with the same parameters as 9.02,
data are loaded with strange encoding but newly created
records are in right encoding.
dbunload -c "uid=;pwd=;charset=utf8"
btw, documentation says
For example, if the database character set is UTF-8, you
should include "charset=utf-8" in the connection strings:
dbunload -c UID=user-ID;PWD=password;
CHARSET=utf-8;DBF=filename -ac UID=user-ID;
PWD=password;CHARSET=utf-8;ENG=server-name -xx
but
dbunload -c "uid=;pwd=;charset=utf-8"
Adaptive Server Anywhere Unload Utility Version 9.0.2.3476
***** SQL error: Database server cannot convert data from/to
character set 'utf-8'
however utf8 works. thus, what is right definiton for utf8?
|
Linear Mode
