469,277 Members | 2,062 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,277 developers. It's quick & easy.

Inserting extended Unicode characters fails

3
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.
Expand|Select|Wrap|Line Numbers
  1. Dim rs As New ADODB.Recordset
  2.  
  3.         rs.Open("select * from  MyTable", DB.Connection, 3, 2)
  4.         rs.AddNew()
  5.         rs.Fields("MyField").Value = "السلام"
  6.         rs.Update()
  7. rs.close()
  8.  
thanks for help
Sep 5 '07 #1
3 2222
pbmods
5,821 Expert 4TB
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?
Sep 6 '07 #2
lovzan
3
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
Sep 6 '07 #3
r035198x
13,262 8TB
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?
Sep 6 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Ivan Voras | last post: by
6 posts views Thread by barthome1 | last post: by
7 posts views Thread by 7stud | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.