Thai Character Support

abhi1901

Hi

How can we enter Thai characters on Form in NAV.

rjmvdven

If I remember correctly, you need to have the following setup:
- your machine should be using the Thai Codepage
- the SQL Server (database) should be using Thai Codepage

Hope this helps.

geordie

Does the SQL Server have to use Thai_CI_AS collation, too?

abhi1901

rjmvdven wrote:

If I remember correctly, you need to have the following setup:
- your machine should be using the Thai Codepage
- the SQL Server (database) should be using Thai Codepage

Hope this helps.

Can you give me some brief that what is this codepage and how can i get tham and install it?

abhi1901

geordie wrote:

Does the SQL Server have to use Thai_CI_AS collation, too?

Sorry I am not a SQL expert so didnt got what you mean by Thai_CI_AS collation.. Can you give me some brief on this?

rjmvdven

abhi1901 wrote:

rjmvdven wrote:

If I remember correctly, you need to have the following setup:
- your machine should be using the Thai Codepage
- the SQL Server (database) should be using Thai Codepage

Hope this helps.

Can you give me some brief that what is this codepage and how can i get tham and install it?

- In your machine's control panel, go to the regional settings, on the last tab you can change your system locale to Thai. This will set your machine to Thai so you will be able to enter thai characters.
- When you are installing SQL Server one of the option during the installation is the selection of the collation. This needs to be the Thai collation as mentioned earlier.
- When you create a new database within NAV you also must select the correct collation.

If you have done all of this, then you should be able to enter Thai characters in the database.

abhi1901

rjmvdven wrote:

abhi1901 wrote:

rjmvdven wrote:

If I remember correctly, you need to have the following setup:
- your machine should be using the Thai Codepage
- the SQL Server (database) should be using Thai Codepage

Hope this helps.

Can you give me some brief that what is this codepage and how can i get tham and install it?

- In your machine's control panel, go to the regional settings, on the last tab you can change your system locale to Thai. This will set your machine to Thai so you will be able to enter thai characters.
- When you are installing SQL Server one of the option during the installation is the selection of the collation. This needs to be the Thai collation as mentioned earlier.
- When you create a new database within NAV you also must select the correct collation.

If you have done all of this, then you should be able to enter Thai characters in the database.

I got your point but the thing is SQL server and Nav is already installed and users are using it from 5 years and again second point is that we have 15 countries on the same database, means we are using the same database and software globally...
In this case how can we do it?

rjmvdven

Then I do not think this is possible. Since you can only set 1 collation per database.