on 2013 Sep 27 12:42 PM
The Unload utility in Sybase cnetral12 does not allow to change the collation. How can I do that in an existing Sybase12 database?
Request clarification before answering.
In addition to Volker's bad news, the COMPARE function aAllows you to compare two character strings based on alternate collation rules...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can't change the collation of an existing database - the collation can only be specified when the database is created.
I guess you would have to create a new database with the according collation first (via dbinit) and then could use dbunload -ac to do an one-step unload into the newly created database.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
29 | |
9 | |
8 | |
7 | |
7 | |
7 | |
6 | |
6 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.