Re: [Zope-DB] DCoracle2 - truncates UTF-8 string with national characters
Are you sure that this is a DCOracle2 problem and not a database problem? UTF-8 may need 5 times more bytes then the character length. Both DCOracle2 and Oracle may get this wrong. Queries from TOAD or sqlplus are returning correct results. I've tried to run sqlplus query as user Zope on the same machine where my Zope instance is and i've received correct results. My ugly hack in dco2.c may be relevant. http://mail.zope.org/pipermail/zope-db/2004-December/003861.html I think it may be helpful. We'll try. Thank you. This is good moment to try SQLRelay too. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] DCoracle2 - truncates UTF-8 string with national characters
Maciej Wiśniowski <[EMAIL PROTECTED]> writes: > We're using DCOracle2 with Zope. On the client machine I've > NLS_LANG = polish_poland.UTF8. > > The problem appears when I'have 30 characters long column in database, My ugly hack in dco2.c may be relevant. http://mail.zope.org/pipermail/zope-db/2004-December/003861.html Wei-Hao ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] DCoracle2 - truncates UTF-8 string with national characters
Maciej Wi-Bśniowski wrote at 2005-5-23 14:54 +0200:-A >We're using DCOracle2 with Zope. On the client machine I've >NLS_LANG = polish_poland.UTF8. > >The problem appears when I'have 30 characters long column in database, >and the text stored in this column contains national characters and is full >length (30 characters). Are you sure that this is a DCOracle2 problem and not a database problem? UTF-8 may need 5 times more bytes then the character length. Both DCOracle2 and Oracle may get this wrong. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db