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. For details, see the SQL Anywhere dbinit documentation at http://dcx.sybase.com/index.html#1100en/dbadmin_en11/dbinit.html.
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.