[Zope] Z SQL Method Problem...
Vitor Varalonga
vpedrosa@ciberbit.pt
Wed, 19 Dec 2001 17:13:45 +0000
--------------71EE163E9EA1F803EF6653D3
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
X-MIME-Autoconverted: from 8bit to quoted-printable by proxy.ciberbit.pt id fBJH87j09352
Hi!
I'm dealing with a very odd problem and I was hopping that someone
among this list could please enlighten me on this matter.
Somewhere within a DTML method I have to call a Z SQL Method that
basically updates an attribute of a specific record on a table (as
described below):
UPDATE Table1 SET attrib1 =3D <dtml-sqlvar attrib1 type=3D"string">
WHERE table_id =3D <dtml-sqlvar table_id type=3D"int">
Whenever I test this SQL Method setting attrib1 with a string containing
extended characters (=F5, =E2, =ED, etc.), I get the following error:
Error, sql.error: ('S1000', -802, '[INTERSOLV][ODBC InterBase driver]
[InterBase]arithmetic exception, numeric overflow, or string truncation,
Cannot transliterate character between character sets')
I thought the problem would lie somewhere in the query or in some
database
definition or property, but when I tested the exact same query with the
same input parameters in IB Expert (Interbase Client Tool) everything
worked out well.
I'm working with an Interbase DB with a common Z ODBC Database
Connection.
Can someone give me a hint in how to solve this problem?
thanks in advance,
Vitor Varalonga
--------------71EE163E9EA1F803EF6653D3
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<tt> Hi!</tt>
<br><tt></tt> <tt></tt>
<p><tt> I'm dealing with a very odd problem and I was
hopping that someone</tt>
<br><tt>among this list could please enlighten me on this matter.</tt>
<br><tt>Somewhere within a DTML method I have to call a Z SQL Method that</tt>
<br><tt>basically updates an attribute of a specific record on a table
(as</tt>
<br><tt>described below):</tt><tt></tt>
<p><tt>UPDATE Table1 SET attrib1 = <dtml-sqlvar attrib1 type="string"></tt>
<br><tt>WHERE table_id = <dtml-sqlvar table_id type="int"></tt>
<br><tt></tt> <tt></tt>
<p><tt>Whenever I test this SQL Method setting attrib1 with a string containing</tt>
<br><tt>extended characters (õ, â, í, etc.), I get
the following error:</tt><tt></tt>
<p><tt>Error, sql.error: ('S1000', -802, '[INTERSOLV][ODBC InterBase driver]</tt>
<br><tt>[InterBase]arithmetic exception, numeric overflow, or string truncation,</tt>
<br><tt>Cannot transliterate character between character sets')</tt>
<br><tt></tt> <tt></tt>
<p><tt>I thought the problem would lie somewhere in the query or in some
database</tt>
<br><tt>definition or property, but when I tested the exact same query
with the</tt>
<br><tt>same input parameters in IB Expert (Interbase Client Tool) everything</tt>
<br><tt>worked out well.</tt>
<br><tt>I'm working with an Interbase DB with a common Z ODBC Database
Connection.</tt>
<br><tt>Can someone give me a hint in how to solve this problem?</tt>
<br><tt></tt> <tt></tt>
<p><tt>thanks in advance,</tt><tt></tt>
<p><tt>Vitor Varalonga</tt></html>
--------------71EE163E9EA1F803EF6653D3--