db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Henning P. Schmiedehausen" <...@intermeta.de>
Subject Re: CLOB needs quotes
Date Wed, 13 Aug 2003 08:44:31 GMT
Dan.Price@equifax.com 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 <dlr@finemaltcoding.com>
>Sent by: dlr@finemaltcoding.com
>08/12/2003 01:52 PM
>Please respond to torque-dev

> 
>        To:     dan.price@equifax.com
>        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" <hps@intermeta.de> on Tue, 
>5 Aug 2003 12:42:32 +0000 (UTC) -----
>To:
>torque-dev@db.apache.org
>Subject:
>Re: [work_java] CLOB needs quotes
>Federico Spinazzi <f.spinazzi@masterhouse.it> 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: torque-dev-unsubscribe@db.apache.org
>>For additional commands, e-mail: torque-dev-help@db.apache.org

>-- 
>Dipl.-Inf. (Univ.) Henning P. Schmiedehausen          INTERMETA GmbH
>hps@intermeta.de        +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 <3F1874B0.6030507@coyotegulch.com>

>---------------------------------------------------------------------
>To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-dev-help@db.apache.org



>-- 

>Daniel Rall




>---------------------------------------------------------------------
>To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-dev-help@db.apache.org

-- 
Dipl.-Inf. (Univ.) Henning P. Schmiedehausen          INTERMETA GmbH
hps@intermeta.de        +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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message