Re: characters stored in databse are displayed As is ...
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. Cheers 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> > >
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format