MySQL Forums
Forum List  »  Knowledge Base

i can not add arabic text to table. text save as question mark ( ????????)
Posted by: a. bahi
Date: August 19, 2009 08:17AM

i have a problem to save arabic data in my tabel.
after run below code, i see question mark in datafield
for example i was insert into test2 this values ('الاهلي','شباب') and when i see content of field after insert, i see : '?????','????'

if i use mysql administrator tools(for windows) and insert into table, anything is correct but when i insert with below code, i see question mark in content of field.

what is problem? please guaid me.

my table name is test2. have 3 fields: f1 (autoincrement , integer) , f2(varchar(45),utf8) , f3(varchar(45),utf8)

this is my asp.net code:
------------------------------------------------------------------------------
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim ConnStr As String = "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=test;uid=test;pwd=test1;"
Dim con As OdbcConnection = New OdbcConnection(ConnStr)


s1 = "(N'" + TextBox1.Text.ToString + "',N'سلامگچ')"

Dim cmd As OdbcCommand = New OdbcCommand("INSERT INTO test2 (f2,f3) VALUES " + s1, con)
Response.Write(cmd.CommandText)
con.Open()
cmd.ExecuteNonQuery()
cmd.Dispose()
con.Close()

dgrAllNames.DataBind()
GridView1.DataBind()

end sub
------------------------------------------------------------------------------

and this is my page:
==============================================================================
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="2-new.aspx.vb" Inherits="_2_new" CodePage="65001"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">;

<html xmlns="http://www.w3.org/1999/xhtml">;
<head id="Head1" runat="server" >
<title>test</title>
<meta name="keywords" content="aaa,ششي ب " />
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"; />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Language" content="fa" />
<link rel="stylesheet" type="text/css" href="style.css" />

</head>
<body>
<form id="form1" runat="server">
<div align="center">
<p align="center">All records in the &#39;Names&#39; table:</p>

<asp:DataGrid ID="dgrAllNames" HorizontalAlign="Center" CellPadding="3" Runat="server" Font-Names="tahoma"
DataSourceID="SqlDataSource1" />

<asp:TextBox ID="TextBox1" runat="server" Font-Names="Tahoma">گفتم چگونه </asp:TextBox>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="character set=utf8;server=localhost;user id=test;password=test1;database=test"
ProviderName="MySql.Data.MySqlClient" SelectCommand="select * from test2">
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"
Visible="true">
</asp:GridView>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button"
CausesValidation="False" />
<asp:Button ID="Button2" runat="server" onclick="Button2_Click" Text="Button2"
CausesValidation="False" />
<p style="font-family: tahoma">
لببيييي ي بل بل بلز بلز ازرژژژژ</p>
<p>
&nbsp;</p> </div>
</form>
</body>
</html>

==============================================================================

Options: ReplyQuote


Subject
Views
Written By
Posted
i can not add arabic text to table. text save as question mark ( ????????)
6344
August 19, 2009 08:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.