Can't restore backup on SQL server

mahesh

Im from india. Trying to restore the russian navision backup (came with CD) on SQL server but im failed with given below error.

---

Microsoft Business Solutions-Navision

---

The Payment Terms table contains a value in a Code field that cannot be used with Microsoft Business Solutions-Navision:

Field: Code
Value: ìÅ

---

main thing is when i tried same on local PC, it worked.
i also installed russian fonts. but then also why it is not possible on SQL server 2003?

plz guid.

Waldo

This is probably because of the codepage you used. Try to use the same codepage as the original DB.

garak

waldo's right. Check the codepage on SQL Server.
The Codepage on SQL Server and the used codepage on Database should be the same.


For you problem, xou have on the orig. Server for example Codepage with kurylix (rusian) but on the new Server Codepage 850 or Latian.

ara3n

If you have two companies, one in china and one in Korea, and they are going to be on the same sql box, will they need two different citrix boxes with different codepages? Can Korea and China be on same codepage?

mahesh

but on sql server, there are already 5 navision databse are there.
If i change codepage to russian then Will it affect other databases??

If Yes then how can i use two language DataBase on same sql server?

ara3n

you would be changing the codepage on the computer that is running finsql.exe not on the server.

mahesh

thanx ara3n,

as im completely novice with CODEPAGE.
so plz could u answer my another Ridiculous question?

Please tell me the steps to change codepage.
Ill be very thankful to u.
_________________
Cheers,
mahESH jain
www.intech-systems.com

kine

1) There are two things you need to set correctly:

a) Collation - it is property of the Database on the SQL server - you can find it in File-Database-Alter dialog. To be able to select another language than your cliet, you need to uncheck the "Check codepage" checkbox or start the client from PC configured to support the language (unchecking th checkbox can lead to character misstranslation and another problems...)

b) Codepage - because the finsql.exe is not unicode application, the "codepage" (which ASCII table will be used to show the data etc.) is driven by settings in "Control Panel - Local Settings - Language for non-unicode applications". This settings must be set to correct language to be able to work with the database.

ara3n

Kine, if you have two companies, Korean and chines in same db through citrix, would they need to have two citrix boxes with different codepages?

kine

I do not know, if you can change the codepage per user in citrix, it means that I must say "I do not know..." :-)

ara3n

It's per computer and effects all the users.