Posted by DL on 02/21/07 09:07

Hi,

Our school has an application in which :
- Teachers enter comments through a web interface built in asp (not
asp.net).
- Comments are stored in a SQL server 2000 (in a nText field)
- Comments are printed through a MS-Access 2002 front-end...

Most comments are in English, Spanish or French. Some comments are
English + Japanese.

- The Japanese teachers can enter their comments through the web
interface without any glitch.
- The comments are obviously stored properly in the nText field, as
they can be displayed through the web interface.

Here is where problems start to occur...

- When browsing through the table using the Enterprise Manager, the
comment appears blank if it contains some Japanese.
- When browsing through the table in Access (the table being linked),
we can see the series of unicodes :
漢字テス... while, in the next paragraph, the
English text is perfectly readable...
- Similarly, on the printed report, the Japanese text appears as a
series of Unicodes, while the English text appears perfactly readable.

If I copy the Japanese text from the web interface and paste it into
the linked table in Access, it displays perfectly and prints perfectly
in Access. But of course, I can't do that manually for all students...
However, if I now look at the same record through the Enterprise
Manager, I see the text (at last !) but only as a series of unreadable
characters. I can imagine that that last problem is due to a lack of
Japanese font in the Enterprise Manager, bacause if I copy these
uneradable characters and paste them in the original web form, they
display perfectly...

I would really appreciate if someone could help me sort out that
problem.
Many thanks for all ideas.

DL

[Back to original message]