Converting Characters

Hi,

Currently I'm using MS-Navision with SQL 2005. Since MS-Navision does not
support Unicode, so whenever I type Chinese/Japanese characters through
Navision, when I do select statements in the SQL Server Management Studio,
or accessing the data through an ASP.NET application, I cannot retrieve
those double-byte characters in the correct format.

I've tried both SQL_1xCompat_CP850_CI_AS and SQL_Latin1_General_CP1_CI_AS
collation as these are settings from Navision application. In both cases,
Navision can display the characters correctly.

Is there a way to write the SQL, or the ASP.NET page, so that I can retrieve
the data in the correct format?

Thanks.

Regards,
Janet