November 9, 2005 at 11:34 am
Hi I am having problem with this data when I insert this in to 2000 I am getting same result but when I do in SQL 7 then I am getting different result
In 2000
insert into test_pass values('bb','bããª^«]ª^ª^ã')
select * from test_pass
bb bããª^«]ª^ª^ã
In 7
insert into test_pass values('bb','bããª^«]ª^ª^ã')
select * from test_pass
bb bã??ãª^«]ª^ª^??ã
I am getting ?? instead of BOX
Thanks
Nita
November 9, 2005 at 1:18 pm
All you are seen is difference in unicode support Client Side.
You shouldn't be using the non representable caracter like that on an insert, istead use the nchar(xx) function to represent the characters you really want.
If you need to compare the results you are better off using a cast to varbinary on the select statement
hth
* Noel
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply