Change the character set and collation

You cannot change the character set, collation, or encoding properties of the database once UltraLite writes the file. You must recreate the database.

To recreate an UltraLite database with a new collation
  1. Unload the database.

    You can use either the Unload Database Wizard in Sybase Central or the ulunload utility. See UltraLite Unload Database utility (ulunload).

  2. Create a new database with the appropriate collation.

  3. Optional. Convert the data to match the new collation if required.

  4. 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).