Dear can you tell me how i insert arabic text in database as arabic text not as ????? when i use ENCType="Mutipart/form-data"


<title> New Page </title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256" -->
</head>

<form action="ElectronicFormUpload.asp" method="post" id=form2 name=form2 ENCTYPE="multipart/form-data">
<tr>
<td>ÇáÇÓã</td>
<td><input type="text" name="UserName"></td>
</tr>

<tr bgcolor="F1F5FA">
<td valign=TOP> ãÑÝÞÇÊ </td>
<td><input type="File" name="AddFile" size="30" ID="File1">
</tr>

<tr>
<td colspan="2">
<input type="submit" name="genubmit" value="ÇÑÓÇá" ID="Submit1"></td>
</tr>
</form>

Dear
This is Form that i use to upload file and one TextBox UserName.
when i type this username in arabic and submit this form i gets the text appear like this ?????? also when i insert this textbox content in sql table the arabic text appear like this ???? in the table

The page use to upload the file and insert the data is
-----
<%@LANGUAGE="VBSCRIPT" CodePage=1256%>
<title> New Page </title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256" -->
</head>
<%
Set objFileUp = Server.CreateObject("SoftArtisans.FileUpEE")
objFileUp.DestinationDirectory = "C:\FileUpLoad"
objFileUp.ProcessRequest Request, False, False
objFileUp.CodePage = 1256
Set oFile = objFileUp.Files("AddFile")
Filename = oFile.ClientFileName
UserName = objFileUp.Form("UserName")
MM_editQuery = "insert into TableForm(UserName,FileName) values('"&UserName&"','"&Filename&"')"
Set MM_Cmd = Server.CreateObject("ADODB.Command")
MM_Cmd.ActiveConnection = MM_ConnSTRING
MM_Cmd.CommandText = MM_editQuery
MM_Cmd.Execute
MM_Cmd.ActiveConnection.Close

oFile.Save
---
Dear can you tell me how i insert arabic text in database as arabic text not as ????? when i use ENCType="Mutipart/form-data"

If you are using SQL Server you will need to adjust the coalition that the column uses so that the text will show up.

I am not sure about any other database such as MySQL or Access.

hth.
-Doug

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========