Create a norwegian database

[Breck_Carter]

We had a database created like this: CREATE DATABASE 'norwegian.db' COLLATION '819NOR' NCHAR COLLATION 'UCA';

But got problems when trying to store characters outside that collation.

So we reloaded the database to: CREATE DATABASE 'norwegian.db' COLLATION 'UTF8BIN' NCHAR COLLATION 'UTF8BIN';

But now we have problem with sorting and comparison. Well sorting we solved with: set option sort_collation='48' or set option sort_collation='UCA(locale=nob)' (not sure if they are equal, or wich to prefere?)

But when comparing: Name like 'Øyv%' or select if 'æ' = lower('Æ') then 'true' else 'false' end if returns false

How do we create a database that will store in UTF8 but sort and compare in norwegian?

[Breck_Carter]

You may find someone with the answer...

If not, consider what a collation-confused person such as myself might do: Perform experiments in which exactly one single variable/parameter/option is changed at a time, followed by all the tests that must be passed to certify "Success!".

Experimental design may take longer than the experiments, but care is necessary to avoid backtracking, wandering, frustration and the inevitable production bugs.

Some parameters to consider are ENCODING and Collation Tailoring Options.

There is a lot of material in the V17 Help here https://help.sap.com/viewer/61ecb3d4d8be4baaa07cc4db0ddb5d0a/17.0/en-US/813826126ce210149074e3a77d2e...

There have been related discussions in this forum and elsewhere so asking Auntie Google my yield fruit (but be careful of obsolete information).

...and people who know the answer do exist, it's just a matter of finding them 🙂

[Former Member]

Hi.

Try to use 1252NOR instead. We always use that in our applications, and it has never created any issues for us.

br,

Bjarne Anker Maritech Systems AS