Insert special characters problem

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Posts: 9
Joined: Tue 15 Nov 2005 13:24

Insert special characters problem

Post by xterm » Thu 09 Feb 2006 18:56

I am trying to insert special characters into mysql 4.1 database using 3.2. My tables have default charset greek. I have also set unicode=true. The special character is placed in a richtextbox which is bind to a field in my database. When i save my data the special character transforms to a question mark when the data return from db. What can i do?

I am using VS.NET 2005 with VB.NET and the character i want to store is (euro)

Please Help...
Sorry for my English


Post by Serious » Fri 10 Feb 2006 07:22

We think the problem might be in data binding. Please test if you can use € character when inserting it from your code. If you sure that the problem is in MySQLDirect .NET send us small test project to reproduce the problem; itis desirable to use 'test' schema objects, otherwise include definition of your own database objects. Do not use third party components.

Post Reply