How to store unicode in SQL Server 2000 with VB

[Martin van der Linden]

Hi,

Can anybody tell me how to store a japanese unicode string from a rich textbox control in a database. I tried rs!Name = RichTextbox1.Text but this generates a bunch of questionmarks. There is nothing wrong with the database because I can use a INSERT INTO to store a japanese string. The problem is how to get it from the richtextbox into the recordset.

Very best regards,
Martin.

PS I have just about read the complete MSDN helpfiles but could not find anything helpful there.

 

[Herfried K. Wagner [MVP]]

Can anybody tell me how to store a japanese unicode string from a rich textbox control in a database. I tried
rs!Name = RichTextbox1.Text but this generates a bunch of questionmarks. There is nothing wrong with the
database because I can use a INSERT INTO to store a japanese string. The problem is how to get it from the
richtextbox into the recordset.

You may want to post the question to this group:

<
Web interface:

<http://msdn.microsoft.com/newsgroup...roup=microsoft.public.dotnet.framework.adonet>