nvarchar in SQL 7

nvarchar in SQL 7

Post by S.Is » Wed, 01 Mar 2000 04:00:00



Hello everybody,

I have imported arabic data from a text file, the arabic data is transfered
into nvarchar data type which can be read perfectly, when I try to assign
this data to a char data type it does not asign it properly . I am using
code page 850 and I have large amount of data so changing the code page
option is not desirable for me . Is there anyway that I can convert nvarchar
data into char without loosing anything. I tried convert function but it
does not seem to work .

ANY SUGGESTION IS HIGHLY APPRECIATED

Thanks in advance,