SELECT * WHERE WORD LIKE '%international character%' 1

[serializer]

I have a table with some mixed content stored in nvarchar. Among the content are chinese and russian characters. I have textbox in a ASP.NET web form. When I enter and search for any chinese or russian text I do not get any results. Any ideas how to solve this?

Thanks!

 

[bborissov]

How about:

SELECT * WHERE WORD LIKE N'%international character%'

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[serializer]

thanks! It worked!