[EMAIL PROTECTED] writes:
I can confirm that CLOB and BLOB work like a breeze with PostgreSQL.
Regards
Henning
>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]
--
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
"Dominate!! Dominate!! Eat your young and aggregate! I have grotty silicon!"
-- AOL CD when played backwards (User Friendly - 200-10-15)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
