db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Henning P. Schmiedehausen" <...@intermeta.de>
Subject Re: LONGTEXT what to do?
Date Wed, 27 Aug 2003 11:15:27 GMT
"Cameron Hickey" <cam@panoramatos.com> writes:

Sorry. :-) The problem is that a String, unless in other langugages
isn't really a collection of Bytes.

So if LONGTEXT is intended to accept a binary value (like a BLOB), you
can't use String.

	Regards
		Henning


>Well it isn't, but thanks for your astute observation. ;)  Isn't a
>LONGTEXT column type a form of VARCHAR?  From what I have read, that is
>what it is supposed to be.  What I am asking is, why has the developer
>of torque mapped the accessor method for this column type to a byte[]
>array instead of to a String?  Is there some performance advantage?  Are
>LONGVARCHARs stored as binary data?  Is this to compensate for some
>other RDBMS which maps this data type to a binary value?  What is the
>advantage of this?

>Obviously handling this inside my application is not difficult, but
>should I choose to store long elements of text in a number of tables
>using torque, then it will be cumbersome to constantly handle for this
>datatype, when all the rest work fine right out of the box.

>How are others handling storing long text chunks using torque?

>Cameron

>-----Original Message-----
>From: Henning P. Schmiedehausen [mailto:hps@intermeta.de] 
>Sent: Tuesday, August 26, 2003 11:13 PM
>To: torque-user@db.apache.org
>Subject: Re: LONGTEXT what to do?

>"Cameron Hickey" <cam@panoramatos.com> writes:

>>Yeah, I just constructed a new string from the byte[].  Is there a
>>reason why this column type maps to a byte[] instead of a string?

>Maybe because it's an array of bytes, not a String? 

>	Regards
>		Henning

>-- 
>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-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-help@db.apache.org


>---------------------------------------------------------------------
>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-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-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message