Forum Moderators: open

Message Too Old, No Replies

Unicode and Access DB

problem displaying Japanese

         

Raymond

8:18 am on Jul 5, 2006 (gmt 0)

10+ Year Member



I tried to enter some Japanese characters into an access database. When I try to query the DB from an ASP script, the Japanese characters turn into "?". What causes this? I have checked the MDB file and the Japanese words are stored correctly. Is this a DB problem of ASP problem?

Thanks alot.

LifeinAsia

3:27 pm on Jul 5, 2006 (gmt 0)

WebmasterWorld Administrator 10+ Year Member Top Contributors Of The Month



What the character set of the page being displayed? How do you enter the data into the database (manually through Access or through a Web interface)? What version of Access are you using? We've had all kinds of problems with Asian charatcers not being stored correctly with versions after '97.

Raymond

5:08 pm on Jul 5, 2006 (gmt 0)

10+ Year Member



Access 2000. I manually typed in the Japanese character. ASP spits out a series of Question marks (not gibberish unicode). My browser is already set to read Japanese.

LifeinAsia

5:14 pm on Jul 5, 2006 (gmt 0)

WebmasterWorld Administrator 10+ Year Member Top Contributors Of The Month



My browser is already set to read Japanese.

What character set are you using to output the page?