DB2 has a native type CLOB, which is already defined in
torque/templates/sql/base/db2/db.props. I have no idea if this actually
works with Torque, because Scarab doesn't appear to use CLOBs, and no
other torquetype maps to CLOB for DB2.
Daniel Rall <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/12/2003 01:52 PM
Please respond to torque-dev
To: [EMAIL PROTECTED]
cc:
Subject: Re: CLOB needs quotes
Dan, any idea on this one? I'd like to nail it before it bites us in
Scarab-land.
----- Message from "Henning P. Schmiedehausen" <[EMAIL PROTECTED]> on Tue,
5 Aug 2003 12:42:32 +0000 (UTC) -----
To:
[EMAIL PROTECTED]
Subject:
Re: [work_java] CLOB needs quotes
Federico Spinazzi <[EMAIL PROTECTED]> writes:
If you tell me what native datatype db2 uses for CLOBs, I could actually
add
it to Torque.... :-) Just "CLOB" ?
Regards
Henning
>Henning P. Schmiedehausen wrote:
>>Hi,
>>
>>for PostgreSQL, a column of the CLOB type (which is PostgreSQL native
>>type text) needs quotes around its value. I don't know about other
>>databases.
>>
>>Currently we have:
>>
>>mysql CLOB = LONGTEXT
>>oracle CLOB = CLOB
>>postgresql CLOB = text
>>sapdb CLOB = LONG UNICODE
>>
>>does anyone know about the other databases? Do they need quotes around
>>the value for one of their columns, too?
>>
>> Regards
>> Henning
>>
>>
>>
>>
>>
>DB2 v8 works with quotes. I don't know the kind of the data type.
>Cheers,
>Federico
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
--
Dipl.-Inf. (Univ.) Henning P. Schmiedehausen INTERMETA GmbH
[EMAIL PROTECTED] +49 9131 50 654 0 http://www.intermeta.de/
Java, perl, Solaris, Linux, xSP Consulting, Web Services
freelance consultant -- Jakarta Turbine Development -- hero for hire
"You are being far too rational for this discussion."
--- Scott Robert Ladd in <[EMAIL PROTECTED]>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Daniel Rall
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
