[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: characters stored in databse are displayed As is ...

japanase characters
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@a...>
To: <xml-dev@l...>
Sent: Wednesday, March 12, 2003 12:09 PM
Subject:  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>


Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
First Name
Last Name
Subscribe in XML format
RSS 2.0
Atom 0.3

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.

Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.