You cannot change the character set, collation, or encoding properties of the database once UltraLite writes the file. You must recreate the database.
Unload the database.
You can use either the Unload Database Wizard in Sybase Central or the ulunload utility. See UltraLite Unload Database utility (ulunload).
Create a new database with the appropriate collation.
Optional. Convert the data to match the new collation if required.
Reload the database.
You can use either the Load Database Wizard in Sybase Central or the ulload utility. See UltraLite Load XML to Database utility (ulload).
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |