Finally, we have found the solution by using the following tag <dtml-var expr="_.string.split(AUTEUR_BIO_FR)"> to display the text really transmitted through ODBC: ['Vous', 'n\222\351chapperez', 'pas', 'au', 'Colonel', 'Moutarde', '!', 'De', 'MADAME', 'FIGARO', '\340', 'MODES', '&', 'TRAVAUX,', 'Moutarde', 'enlumine', 'les', 'pages', 'des', 'plus', 'grands', 'ma\000gazines.', 'Des', 'INROCKUPTIBLES', '\340', 'OKAPI,', 'le', 'Colonel', 'baladait', 'son', 'charme', 'et', 'ses', 'images', 'aux', 'couleurs', 'lumineuses', 'quand', 'la', 'passion', 'de', '\000la', 'BD', 'l\222a', 'surpris', 'au', 'd\351tour', 'd\222une', 'page', 'de', 'L\222\311QUIPE', 'MAGAZINE.', 'Et', 'en', 'bande', 'dessin\351e', 'comme', 'en', 'illustration,', 'le', 'Colonel', 'Moutarde', 'd\000onne', 'le', 'meilleur', 'de', 'lui-m\352me', '!'] As you can see, there is a special caracter \000 is some words most probably inserted by SQL Server every 125 caracters and Netscape reacts inconsistently. The solution was simply to remove this caracter with the following tag: expr="_.string.replace(AUTEUR_BIO_FR,'\000','')" So the problem wasn't inside Zope...
Pierre Dricot a écrit :
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="#0000FF"> Vous néchapperez pas au Colonel Moutarde ! De MADAME FIGARO à MODES & TRAVAUX, Moutarde enlumine les pages des plus grands ma gazines. Des INROCKUPTIBLES à OKAPI, le Colonel baladait son charme et ses images aux couleurs lumineuses quand la passion de la BD la surpris au détour dune page de LÉQUIPE MAGAZINE. Et en bande dessinée comme en illustration, le Colonel Moutarde d onne le meilleur de lui-même ! <BR>
Netscape: <font color="#0000FF"> Vous néchapperez pas au Colonel Moutarde ! De MADAME FIGARO à MODES & 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échapperez pas au Colonel Moutarde ! De MADAME FIGARO à MODES & TRAVAUX, Moutarde enlumine les pages des plus grands magazines. Des INROCKUPTIBLES à OKAPI, le Colonel baladait son charme et ses images aux couleurs lumineuses quand la passion de la BD la surpris au détour dune page de LÉQUIPE MAGAZINE. Et en bande dessinée comme en illustration, le Colonel Moutarde donne le meilleur de lui-même ! --------------------------------------------------------------------------------
SQL Used: select AUTEUR_ID, AUTEUR_BIO_FR from AUTEURS where AUTEUR_ID = 149
Thanks for your help !