How to change code page in navision

kmkaot

Hi,

Do anyone can suggest me/guide me how to set codepage in navision.
I want type Arabic in Item card description field

Please warm regards
kris

Slawek_Guzek

Hi,

As I have writen this the display fonts/keyboard/left or right text reading direction is all governed by the operating system settings. None of those are controlled by NAV.

If you copy and paste arabic text into a text box NAV treats is as a stream of bytes. Nothing more. It it Windows deciding how to dispalay them

Have you tried experimenting with operating system language on your computer?


Slawek

Slawek_Guzek

Hi,

If you want to type in Arabic you need to have an Arabic regional settings and arabic keyboard layout. This is the operating system setting, nothing to do with NAV.

The database codepage (or more precisely collation) will only let you to store and sort correctly typed characters. You cannot change the it within the code, or just for one table or field. It is a database property which is decided during database creation, and can be changed later on by setting the database in single user, and then changing collation in Tools -> Database-> Collation.

You can start with unticking the "Validate Collation" box which is sometimes helpful when you need to store a characters outside the current database collation - but you need to be aware that converting such a string to lower/upper case will mess entered data. Also when you sort on such field the results will likely be incorrect.

In your case if you type something in Description, most likely the "Search Description" will be updated incorrectly.

Slawek

kmkaot

I have only Navision native database and I am not using SQL. when I phase arabic text in the navision item description field it is showing junk but printing. issue is the text is breaking and also left alignment. It should be right aligned.

Please suggest..

Slawek_Guzek

Hi,

As I have writen this the display fonts/keyboard/left or right text reading direction is all governed by the operating system settings. None of those are controlled by NAV.

If you copy and paste arabic text into a text box NAV treats is as a stream of bytes. Nothing more. It it Windows deciding how to dispalay them

Have you tried experimenting with operating system language on your computer?


Slawek

Kowa

Take a look at the end of this thread
https://forum.mibuso.com/discussion/30604/nav-in-arabic

You can also access some hidden functions in the MenuSuite by hitting F2 when editing captions as I explained here in German.
http://www.msdynamics.de/viewtopic.php?f=40&t=14653&p=72654&#p72649

kmkaot

thank you.
will you tell me how to align text from right to left.

warm regards

Slawek_Guzek

There are no global settings in NAV allowing changing text alignment across the board. Default text alignment, or rather directionality, is controlled by Windows. If it is not somewhere in Regional Settings in Control Panel then I don't know if and where it can be. Perhaps there are some Windows registry settings allowing
controlling text directionality in the OS, but I am not aware of any.

However.

Each control on a form or a report has a property called HorzAlign, where you can set it to be left, center or right. Changing test alignment requires editing the form, and changing the property.

It can be easily done in one form and a few controls, but it is a fixed setting only to be changed by changing the form/report field.

However easy it sounds there is a price that will have to be paid for that at the upgrade time. All modified standard objects would have to be reviewed then, and assessed if the modification is important and needs to stay, or it can or must be dropped in new system. HorzAlign is not available in new system, but someone will need to anayse all modified object and check if modifications are only the HorzAlign property changes, or maybe something else had been changed on the form, and it must be transferred to a page.

So be careful with Object Designer.

Slawek