SA16: How to change the DB property "HasNCHARLegacyCollationFix"?

[former_member209084]

Or, is this property changable?

We migrated a DB from SA10 to SA16, but found that the sorting of some query result has changed. So I look for any sorting-related DB property that is different between our SA10 DB and SA16 DB, and found this one suspicious....... or I could be wrong.

[jeff_albion · Accepted solution]

Hi Henry,

The property is not changeable on an existing database. The flag is really indicating if the database was created prior to CR #480072 or not. For further details, see: http://search.sybase.com/kbx/changerequests?bug_id=480072

It is quite possible that the ordering has 'changed' but it may no longer be 'incorrect' due to the same above fix that introduced the property.

Which exact version of SQL Anywhere 10 are you migrating from - is it prior to CR #480072 (10.0.1.3564)? It sounds like you might be on a lower version than this if the property doesn't exist in your version 10 database. Also, which version was the the database created on? (SELECT * FROM SYS.SYSHISTORY)

Regards,

Jeff Albion

SAP Active Global Support

[former_member209084 · Accepted solution]

The SA10's version is 10.0.1.3629.

The property exists in our SA10 DB, but the value is 'off'.

In our SA16 DB, its value is 'on'.

btw, the DB was originally created by SA7 or so. Some years ago we migrated it to SA10.

So, is there any way to change the sorting back to how our old DB does?

Although it might be objectively incorrect, it's what our system's users considered as correct........

[jeff_albion · Accepted solution]

Hi Henry,

What is the actual collation for the NCHAR data on the SQL Anywhere 10 database? What is it currently for the SQL Anywhere 16 database? Are they the same or different?

See: http://dcx.sybase.com/index.html#1001/en/dbdaen10/da-determining-serverlocale-natlang.html

SELECT DB_PROPERTY( 'NcharCharSet' );
SELECT DB_PROPERTY( 'NcharCollation' );

How did you rebuild the database on SQL Anywhere 16, exactly?

Can you describe the actual sorting problem you're looking at with sample data? Does it include certain characters, accent sorting, ...?

Regards,

Jeff Albion

SAP Active Global Support