When I Compare Two String In Unicode Format.

Hi,
I have a funny Error in our sql server 7 & 2000. When I compare two
string in Unicode format. I receive that it is the same when I add new
nchar.
I don’t understand why?


Could you help me ?

declare @str nvarchar(128), @str2 nvarchar(128)



Set @str =
nchar(21121)+nchar(49352)+nchar(47811)+nchar(48256 )+nchar(4966)+nchar(25
736)+nchar(1788)+nchar(51220)+nchar(17733)

Set @str2 =
nchar(21121)+nchar(49352)+nchar(47811)+nchar(48256 )+nchar(4966)+nchar(25
736)+nchar(1788)+nchar(51220)+nchar(17733)+nchar(4 1273)



select @str

select @str2

SELECT DIFFERENCE(@str, @str2)



if soundex(@str) = soundex(@str2)

BEGIN

SELECT 'OK'

END

ELSE

BEGIN

SELECT 'KO'

END

if @str = @str2

BEGIN

SELECT 'OK'

END

ELSE

BEGIN

SELECT 'KO'

END


-=zoltux=-

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!