Insert special characters problem

Insert special characters problem

Postby xterm » Thu 09 Feb 2006 18:56

I am trying to insert special characters into mysql 4.1 database using mysqldirect.net 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
xterm
 
Posts: 9
Joined: Tue 15 Nov 2005 13:24

Postby 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.
Serious
 


Return to dotConnect for MySQL