Wrox Programmer Forums
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old May 17th, 2008, 05:22 AM
Registered User
Join Date: May 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default ENCType="Mutipart/form-data"

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" -->

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

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

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

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" -->
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

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

Old May 17th, 2008, 08:12 AM
Wrox Author
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons

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.


================================================== =========
Read this if you want to know how to get a correct reply for your question:
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

Similar Threads
Thread Thread Starter Forum Replies Last Post
ENCTYPE="multipart/form-data" Issue software_developer_kk Classic ASP Basics 7 June 24th, 2007 10:08 AM
Query data in form Vince_421 Access 2 February 1st, 2007 10:45 AM
EncType="multipart/form-data" vackir ASP.NET 1.0 and 1.1 Basics 1 August 12th, 2006 02:28 PM
FORM data not valid js_pandey Beginning PHP 2 June 3rd, 2005 06:10 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.