Initializing a New Consolidated Database

If you are experiencing incorrect string comparisons, you may need to initialize a new database to ensure that comparisons occur correctly. Incorrect string comparisons only occur when you either use a SQL Anywhere database that has not been installed and set up with the Unwired Platform installer.

Initialize a database using the dbinit utility. This utility is located in <UnwiredPlatform_InstallDir>\Servers\SQLAnywhere11\BIN32.

By default, SQL Anywhere creates a database treating a trailing blank as any other character in comparisons during collation. To avoid treating trailing blanks as significant characters, a CDB should be created with the "-b" option that directs SQL Anywhere to ignore trailing blanks in any comparison.

Run dbinit using this syntax: dbinit -z UTF8 -zn UTF8 -b
Where:
  • -z UTF8 sets the collation sequence data as UTF8.
  • -zn UTF8 sets the collation sequence for sorting and comparing to UTF8.
  • - b sets up blank padding.
Related tasks
Changing the Consolidated Database Server Thread Count and Pool Size
Using a Different Database and Log Path