>Hi All!!!
>
>I'm working on a project wherein we need to upload/store transactions/ information that has chinese characters. My question is:
>
>1. What data type should I use to store this type of data?
>2. How do I do a search on this field?
>
>Thanx! a lot in advance...
>
>Martin

You should use Nvarchar or NChar (National chars). The search is almost the same but you should use N' infront of your seacrhed string:

SELECT .....
       FROM ....
       WHERE TheText  = N'SomeChineseTextHere'

Also make sure you have the right colation for that DataBase.