OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   Re: [xml-dev] characters stored in databse are displayed As is ...

[ Lists Home | Date Index | Thread 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.  

Rick Jelliffe

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" <qazi@advcomm.net>
To: <xml-dev@lists.xml.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>


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS