The Help says this...
Collations In version 9 and earlier, SQL Anywhere supported one collation used with CHAR data types. This collation used the SQL Anywhere Collation Algorithm (SACA). In version 10 and later, SQL Anywhere supports two collation algorithms, SACA and UCA (Unicode Collation Algorithm). Unless you specify a new or different collation for the rebuilt database, the SACA collation from the old database is unloaded and reused in the rebuilt database. http://dcx.sybase.com/index.html#1201/en/sachanges/unloading-reloading-upgrading-newjasper.html
Is it possible to specify UCA for the new database when using dbunload in a single step (internal unload)?
asked 12 Apr '11, 12:12
As Volker noted, you need to create the database first and then use dbunload -ac. On Windows, it will use an OS named piped to transfer table data between the V9 engine and the V12 engine.
answered 13 Apr '11, 14:13