Inserting extended Unicode characters fails

[lovzan]

hello;
i work on vb.net with mysql database i use ADO.
the problem is that i can't insert into the table arabic or other unicode string.

Dim rs As New ADODB.Recordset
 
        rs.Open("select * from  MyTable", DB.Connection, 3, 2)
        rs.AddNew()
        rs.Fields("MyField").Value = "السلام"
        rs.Update()
rs.close()
 

thanks for help

[pbmods]

Heya, lovzan. Welcome to TSDN!

Changed thread title to better describe the problem (did you know that threads whose titles do not follow the Posting Guidelines actually get FEWER responses?).

Please use CODE tags when posting source code. See the REPLY GUIDELINES on the right side of the page next time you post.

What happens when you try to insert the data? Do you get an error message? Does MySQL generate an error?

[lovzan]

Hello,

When I want to insert Arab text, the compiler generates an error and does not make insertion at the base mysql, I tested it on an access database, and it passes well.
the error is on the driver of mysql: i used
DRIVER={MySQL ODBC 3.51 Driver};
thanks

[r035198x]

Hello,

When I want to insert Arab text, the compiler generates an error and does not make insertion at the base mysql, I tested it on an access database, and it passes well.
the error is on the driver of mysql: i used
DRIVER={MySQL ODBC 3.51 Driver};
thanks

How about posting the error message that you got?