HI,

I'm going to create an application that will accept user inputs as
English Language and the Japaneese Language and store in to the
SQL server database.

I did the following,

1. Create a SQL Database table using one Field as the type ntext
2. Design a form from the VB 6 using MS Rich Text control and bound that to the ADO data control
which connect to the SQL database
3. From the Regional setting I had change the Input Language as the Japaneese

Now I can write and retrieve the Japaneese text to the SQL Database using the VB form.

Now I want to search a japaneese string from the database

Wow can I do that ???

I had tried several ways but I couldn't
Any one can help me much appriciated.

Thank,
Chamil Mendis MCP,MCSD
chamilm@jkcs.slt.lk