[Zope] Text truncated by Netscape (but not by Explorer)

Pierre Dricot dricot@dupuis.be
Tue, 27 Mar 2001 11:41:01 +0200


A long text description is stored as ntext(16) in a MSSQL7 database and
retrieved trough ODBC (ZODBCDA-3.1.0b2-win32-x86). Zope
(Zope-2.3.0-win32-x86) runs on a W2000 server.

This long description is displayed correctly by Explorer (V5.0) but
truncated by Netscape (V4.5).

The source page displayed by each navigator is quite different:

Explorer:
<font color=3D"#0000FF">
Vous n=92=E9chapperez pas au Colonel Moutarde ! De MADAME FIGARO =E0 MODE=
S &
TRAVAUX, Moutarde enlumine les pages des plus grands ma gazines. Des
INROCKUPTIBLES =E0 OKAPI, le Colonel baladait son charme et ses images au=
x
couleurs lumineuses quand la passion de  la BD l=92a surpris au d=E9tour
d=92une page de L=92=C9QUIPE MAGAZINE. Et en bande dessin=E9e comme en
illustration, le Colonel Moutarde d onne le meilleur de lui-m=EAme !
<BR>

Netscape:
<font color=3D"#0000FF">
Vous n=92=E9chapperez pas au Colonel Moutarde ! De MADAME FIGARO =E0 MODE=
S &
TRAVAUX, Moutarde enlumine les pages des plus grands ma<BR>

As you can see, it seems that there is a special caracter exactly where
the text is truncated by Netscape: the french word "magazines" is in two
words in Explorer ("ma gazines"). Another word ("donne") at the end of
the text is also in two words ("d onne"). This special caracter seems to
appear every 125th caracter in the text description and is ignored when
displayed by explorer.

I'am surprised by the fact that Zope seems to have a different behaviour
depending on the navigator used,  because the content of the generated
page is different for each one.

Moreover, the same text retrieved when testing the OBDC connection
inside Zope doesn't have these special caracters  as you can see below:
Z ODBC Database Connection at  /eCatalog/ZopeCatalogueProduction
-------------------------------------------------------------------------=
-------

AUTEUR BIO FR
Vous n=92=E9chapperez pas au Colonel Moutarde ! De MADAME FIGARO =E0 MODE=
S &
TRAVAUX, Moutarde enlumine les pages des plus grands magazines. Des
INROCKUPTIBLES =E0 OKAPI, le Colonel baladait son charme et ses images au=
x
couleurs lumineuses quand la passion de la BD l=92a surpris au d=E9tour
d=92une page de L=92=C9QUIPE MAGAZINE. Et en bande dessin=E9e comme en
illustration, le Colonel Moutarde donne le meilleur de lui-m=EAme !
-------------------------------------------------------------------------=
-------

SQL Used:
select AUTEUR_ID, AUTEUR_BIO_FR
from AUTEURS
where AUTEUR_ID =3D 149


Thanks for your help !