vb mysql编码到希伯来文
问题描述:
*我使用Wampserver,visual studio 2015和vb。vb mysql编码到希伯来文
当我添加希伯来值的新条目到数据库时,我得到的是正确的字符而不是一个问号(“???”)。
当我使用VB
补充说,通过代码时才会发生,但如果我用phpMyAdmin的使用,它是做正确的。
这是我在VB代码:
Dim MyConn As New MySqlConnection("Server=localhost;User Id=admin;Password=1234;Database=game")
Dim BaseTable As New DataTable
Dim MyAdapter As New MySqlDataAdapter("select * from users", MyConn)
Dim mydatarowscommandbuilder As MySqlCommandBuilder = New MySqlCommandBuilder(MyAdapter)
Dim xRow As DataRow
MyAdapter.Fill(BaseTable)
xRow = BaseTable.NewRow()
xRow("id") = 5515
xRow("Nick") = "דן"
BaseTable.Rows.Add(xRow)
MyAdapter.Update(BaseTable)
答
添加字符集连接字符串,像这样:
Dim MyConn As New MySqlConnection("Server=localhost;User Id=admin;Password=1234;Database=game;Charset=utf8")
这是为了使u标记它交配 – Tsar
“感谢您的反馈!获得总共15个声望后,您的选票将改变公开显示的帖子分数。“ – MrSomeone