cannot select chinese records

From: Jerry Lee (jerrylee_at_suncypress.com)
Date: 02/20/04 

Date: Thu, 19 Feb 2004 21:00:09 -0800

Hi all,

I have some problem when selecting records starting with
chinese characters in my SQL Server

All records can be displayed when I type 'Select * from
[Table]', But when I just want to select some chinese
records and I typed 'Select * from [Table] where [Field1]
like '中文%', no records could be dispalyed

Do anyone has the idea?
Thanks a lot