db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Cameron Hickey" <...@panoramatos.com>
Subject RE: LONGTEXT what to do?
Date Wed, 27 Aug 2003 07:04:32 GMT
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


Mime
View raw message