Question Title: Kanji feilds ( japanese c

I have been in the process of converting a english asp shopping cart with a access db into japanese. 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



Edited by Akumaownz - 29 January 2005 at 12:33pm