cancel
Showing results for 
Search instead for 
Did you mean: 

how to change collation in a Sybase12 dtabase from command line

Former Member
2,806

The Unload utility in Sybase cnetral12 does not allow to change the collation. How can I do that in an existing Sybase12 database?

Accepted Solutions (0)

Answers (2)

Answers (2)

Breck_Carter
Participant
VolkerBarth
Contributor

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.