Error while trying to restore to SQL server

Suja

Hi

We have performed a database upgrade from NAvision Native 2.6 to NAvision 4.0 Sp1 (Native DB) successfully. The database contain lots of chinese captions and also some of the datas are also in Chinese.

After upgrade , now we want to convert the database from Native to SQL Server 2000 environment.I did a full backup of the Native database (objects & datas) and while trying to restore to the newly created database in SQL it prompts me the error ..

"Customer Price Group Contains a value in a Code field that cannot be used with MBS- NAvision

Field - Code
Value - <some funny characters>

Any advice/ideas are greatly appreciated

Regards
Suja

ara3n

You need to select a coalation that has Chinese characters. Otherwise you can't have chinese characters in any key. So you option is to rename the code to integers.

mgm

I ran into the same error.
Is there any tool with which you can check for 'funny' characters?
So, something you can use in the native database that checks if the collation you want to use in SQL will cause any errors.