Sorting error with scandinavian characters on "classic" db

kennet_lindberg

Hi,

I have a problem with the sorting of scandinavian characters. Å, ä, ö is sorted ä, ö, å. The problem seems to exist in versions 5.0 SP1 through 2009 SP1 running on Navision database.

Anyone come across this problem and found a solution?

/Kennet

herrlutz

seems you have chosen the wrong SQL Codepage / Collation.
i don´t know the right one for Scandinavia.
ín order to find the right one, you have to set your Windows settings for "Regional Setting" on the NAV client (or Citrix) in Folder "Extended". Here set feature "Codepage for non Unicode Programs" to Danish (or Norwegian, Swedish).
Then go to Navision, Database/Alter, Collation.
Here activate "Validate Codepage", then you can select the Codepages that are supported for that country. This is where my knowledge ends telling you exactly which one you have to choose.

Also, changing the Codepage in an existing database will have as effect, that some characters will be substituted. This might create some data- rubbish. So be careful.
regards
Alex

jannestig

Maybe you should read the title again database type = Classic

herrlutz

correct... my comment is in regard to SQL...

kine

kennet_lindberg wrote:

Hi,

I have a problem with the sorting of scandinavian characters. Å, ä, ö is sorted ä, ö, å. The problem seems to exist in versions 5.0 SP1 through 2009 SP1 running on Navision database.

Anyone come across this problem and found a solution?

/Kennet

I think that the sorting order is written in the fin.stx file. CHeck the string there. If it is wrong, than it is localization bug. If it is correct, than problem must be elsewhere...

kennet_lindberg

I found the reason of this problem. As kine pointed out, the sorting is written in the stx file. I had created the database using a W1 stx file.

To solve my problem I created a new database "using" a swedish stx file and then restored a backup of the original database in it and then it worked.