"Cameron Hickey" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]
>Sent: Tuesday, August 26, 2003 11:13 PM
>To: [EMAIL PROTECTED]
>Subject: Re: LONGTEXT what to do?
>"Cameron Hickey" <[EMAIL PROTECTED]> 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
>[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]
>---------------------------------------------------------------------
>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]
