Lists Home |
Date Index |
That string seems to be ShiftJIS, if that is any help.
Instead of a large string, I suggest you first test just using a single
Japanese character in the HTML field. This makes it easier to figure
out what is happening with encoding (especially whether 1, 2 or 3
bytes are being used per character.)
I suggest using "binary chop" for this problem: divide and conquer.
Start by inserting into your database a Japanese character you know
is correct (use a program for this). Then see if it makes it to the HTML.
If it doesn't, binary chop: see if the HTML file is correctly labelled and has
the byte you expect. If it does, check the browser can read that encoding
and that you have the correct fonts installed. (On some Windows systems
you will have to install Japanese fonts.)
Once you know the front-half works, if the whole thing does not work,
then your back-half has a problem. Binary chop: make your ADO code
generate a single Japanese character and see whether that makes it to the database. If so, then the problem is between your form and the ASP/ASO.
I hope this is some help.
P.S. This does not seem to be an XML issue. You should use an
HTML or MS mailing list. They can suggest the typical problems
that may be happening, but it is better if you are in control of your
code and can verify that each stage is working the way you expect
it. The worst thing that can happen is that you can corrupt the
database with data that uses different encodings: then you really
would have to figure out encoding issues.
----- Original Message -----
From: "asim" <firstname.lastname@example.org>
Sent: Wednesday, March 12, 2003 12:09 PM
Subject: [xml-dev] characters stored in databse are displayed As is ...
> HI list, i m having a problem plz help
> Problem: I pasted some japanase characters in a Html text field and submited
> form to an ASP file and using ADO i inserted the value of text field in a
> MsAccess database table (field:Name, Type:test) some this type of characters
> were stored in DB "Œv‰æ‚Ìƒ}ƒl[ƒWƒƒ[ " now when i query the DB and make a
> xml packet, then using transformNodeToObject i transfrom it and make HTML,
> when i view these characters on browse these characters as is r written on
> the browser,
> so what to do to show the actual language (japanese) characters
> PLz Help
> Qazi Asim
> The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
> initiative of OASIS <http://www.oasis-open.org>
> The list archives are at http://lists.xml.org/archives/xml-dev/
> To subscribe or unsubscribe from this list use the subscription
> manager: <http://lists.xml.org/ob/adm.pl>