Tip #5 – Multiple country databases; Validate Codepage

This Blog Article was brought forward from my old blog

As you might be aware of, the NAV client is not Unicode compliant.

[Update 2014, since this was posted in 2009, NAV is Unicode compliant, however Codepage is still used for sorting ]

Usually this is not a big issue since NAV is orriginaly used in countries that do not require double byte characters and generaly NAV installations are single country, so one codepage is enough.

I will blog more about codepages in the furure but for now I want to focus on the option to activate multiple codepages.

When you start up the NAV client it checks if the codepage on your windows system matches the STX file. Also when you create a new database it will only let you pick a collation in your region.

To override this, you can go to the settings of the SQL database in File -> Database -> Alter.

If you uncheck the “validate codepage” flag the check is no longer performed.

Be carefull because if a codepage contains a character that is not supported in the other codepage, you might see rubbish.

As long as this is not a problem for your organisation than it is ok.

Leave a Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.