Working with Japanese text in Access 2003 using ASP

[×ורן מור]

I have a web site working with ASP pages.
The text is store in MS Access 2003 database.
I need to make the same web site in Japanese, when I change the text in the
database to Japanese from English I get display with ??? Marks.
I change the encoding to utf-8 and Japanese but the problem still going.
Thanks for any help

 

[Wayne-I-M]

Hi

Just an idea. When you create the asp form (I think that is what you are
using) go to "saved fields" and use the "value" option. This way you would
not need to convert to database to another language. So if you have a form
with an option box

Option 1 = ABC
Option 2 = DEF
Option 3 = GHI

You can use the saved fields option of the asp form to store the values you
want.

This way it does not matter what you put in the option box as it is the
Value that is stored in the database.

It may take a while as you will need to set a value for each option but it
does work as we have a simlar system for booking from russia (I do not speak
this langauge but the values saved into the DB are what I can undertand).
Note russian does not use a european lettering system so there would be the
same with Japanese I think.
Here is an eample
http://www.folgarida.co.uk/folgarida_external.htm#Rus



I hope this may be a idea - or someone else could answer with something.

 

[Tom Wickerath]

I have a web site working with ASP pages.

The text is store in MS Access 2003 database.

You may have created this database using Access, but, technically speaking,
you are using a JET database with your ASP pages. Access is not involved at
all when reading/writing data from your ASP page.

Make sure that the Unicode Compression property is set to No for any fields
that you need to store Japanese text in. If you created your database using
Access 2000, 2002 or 2003, then Unicode Compression is set to Yes by default
for all text and memo data types. If you used Access 97 to create the fields,
then Unicode Compression is not set to Yes by default, even if you later
convert the .mdb file to the JET 4 file format.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________