Japanese text gets garbled with enctype="multipart/form-data"

I am having a page with
<form id="frmTest" method="Post" ENCTYPE="multipart/form-data">

so it uses Set Upload = Server.CreateObject("Persits.Upload.1") to access the form elements. and for file uploading.

There is also a field "additional_comments" which is being accessed as :
additional_comments = Upload.Form("additional_comments")

Now the data is saved correctly if entered in English, but if I enter Japanese text it gets garbled by the Upload object and hence is not saved correctly.

I understand that u cannot use Request.Form("additional_comments") along with ENCTYPE="multipart/form-data"..   so how do I save the Japanese comments ??
I am sure this is being done on various Japanese sites..... PLEASE HELP !!!!!
LVL 1
DeepBlueInVBAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

masirofCommented:
Try to use
@Codepage = 932 (I think it is 932 for japanese)
Session.LCID = 1041

I am not really sure about numbers, you may have to check.
0
riyasjefCommented:
Hi

when u save details database field corr:to additional_comments must be of type "nvarchar" to support multilanguges..
Also in the query should be

INSERT INTO tableName(id,additional_commentsField) VLAUES (1,N'"& additional_comments & "')

Note 'N' - prefix for nvarchar field

put

<%@ language=vbscript codepage=65001 %>
<meta http-equiv="content-type" content="text/html;charset=utf-8">

in the top


RJ
0
riyasjefCommented:
put this in the comment viewing page

<%@ language=vbscript codepage=65001 %>
<meta http-equiv="content-type" content="text/html;charset=utf-8">

RJ
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

riyasjefCommented:
nchar and nText are also national language suppot data types
0
DeepBlueInVBAuthor Commented:
I have already put the foll at the top

<%@ language=vbscript codepage=65001 %>
<meta http-equiv="content-type" content="text/html;charset=utf-8">


also the database field is indeed nvarchar, but the problem is that the Japanese gets garbled on the form itself (before db update)

I have other pages with similar data, without the file upload part, where the Japanese data gets saved fine, with the codepag and content-type directives put in..

Any ideas guys!!!!
0
masirofCommented:
You may try to tell database that a japanese encode type query is to come..
execute this command "set language japanese" just before u insert ur data..
0
DeepBlueInVBAuthor Commented:
set language japanese,  is not required, like I said, I have other pages (without Upload facility) saving Japanese text just fine !!!!
0
DeepBlueInVBAuthor Commented:
200 Bonus points, if I get the solution before Monday !!!!
0
masirofCommented:
Eheheeh :))) Too few, more :))
0
masirofCommented:
Try to put this : <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=SHIFT-JIS">  on both saving and sending pages..
0
masirofCommented:
And try unicode too
0
DeepBlueInVBAuthor Commented:
Try to put this : <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=SHIFT-JIS">  on both saving and sending pages..
 

This has already been done, doesnt work....

what about Unicode ????

and no more points !!!!  500 + 200 bonus (if bfor monday)
0
masirofCommented:
:))
Ok, please try to print on the saving page. Do you get data OK?
0
masirofCommented:
ok, hold I am trying to figure out..
0
masirofCommented:
You say that other pages without enctype everything cool.

Maybe  : http://www.aspupload.com/manual_unicode.html

On top : <%@ LCID = 1041 CodePage = 932 %>
Please try..
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DeepBlueInVBAuthor Commented:
oks shall try this out on Monday....
0
masirofCommented:
waiting.. :)
0
DeepBlueInVBAuthor Commented:
Oks got it by Monday, mucho thanx Masirof

The solution is to put Upload.codepage = 65001, after the CreateObject statement.....  

Just post a comment on the foll question for the 200 points!!!

http://www.experts-exchange.com/Web/Q_21206938.html
0
DeepBlueInVBAuthor Commented:
Sorry Masirof, looks like its against the policy !!!!!

=======================
I have deleted this question as it violates the Member Agreement regarding abusing the points system.
A question can have a maximum of 500 points assigned which you allready awarded at http:Q_21201377.html
CetusMOD
Community Support Moderator
=======================
0
masirofCommented:
No problem :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.