I have been in the process of converting a english asp shopping cart with a access db into japanese. http://www.ozhorse.info/comersus/ - http://www.ozhorse.info/comersus/
The
shop works as a normal shopping cart would with new customers able to sign via a form which
stores there details in a access db. When they place a order from the
shop a email is compliled from their shopping cart and the details.
I have every working and translated and the cart is working fine visually as a webpage.
The problem is the kanji feilds (japanese characters) arn't being stored in the access db correctly.
The
strange this is that when these feilds are called they dispay correctly
on the html page that is compliled via the db and asp, but when the
email order comes through all the fields that where called from the
access db are corrupt and display like this ?^???O”I ??0
Example of a email order:
_______________________________
お客様へ Bill Gates
OZショップにてお買い物して 戴きありがとうございます 290;
あなたのご注文商品は以下&a mp;# 12398;通りです。
1x #RDHT/11
Red Hat Deluxe WorkStation オプション：= ??79
Bank of ?^???O”I ??0
N/A
??0
GST（オーストラリア消費税） ; ;??0
-------------------
ご注文合計金額
??79
_______________________________________
As you can see no even the yen symbol is making it through.
To process the forms and email orders I am using <%@ Language=VBScript CODEPAGE=932 %> To force japanese
I have made the font on the db @Arial Unicode MS
If I download the access db and look at the fields that have been entered they display as junk i.e. ?^???O”I ??0
I am using jmail to process the email orders.
I have noticed that webwiz forums supports japanese or unicode so how
do you guys you get the japanese feilds into the db correctly????.
Please note I am just a beginer at asp
|