|
|
Posted by DL on 02/22/07 08:36
Hi Erland,
Yes. I see the ampersand, hash mark, digits and semicolon.
That's actually a good point. It would mean that the problem is with
the communication between the asp pages and the sql server : asp that
would let the user type Japanese characters in the text control, but
the typed text would be translated into the sequence of ampersand,
hash mark, digits and semicolon...
That would also explain what I discovered after having posted my
message : I went back to similar data that was entered in an Access
database last year and years before, using Access as a front-end. The
Japanese text always printed properly and was never a problem. I
transfered it to the sql server and looked at it through the new web
interface : it displayed as series of question marks (?????80%????...)
Do you by chance know how I could eliminate that problem linked to the
web interface or do you suggest I post the question on an asp list ?
Thanks for helping me clarify the source of my problem,
DL
On Feb 21, 11:58 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> DL (lalo...@isb.be) writes:
> > - When browsing through the table using the Enterprise Manager, the
> > comment appears blank if it contains some Japanese.
>
> What do you see in Query Analyzer?
>
> > - 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...
>
> Do you actually see the ampersand, hash mark, digits and semicolon?
> In such case, I would assume that the page writes that do the database.
> The browser will present those codes correctly, but obviously Access
> will not.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|