mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 26, 2001 9:29 AM
> To: Michael Champagne
> Cc: PHP General Mailing List
> Subject: Re: [PHP] Help with PHP/Oracle and serializing data
>
>
> In Oracle, 'long' is a variable-length character data column up to 2GB in
>
I used them all over on a large PHP3 (and later PHP4) site for several years
until we migrated to PostgreSQL in January, with no problems.
What's the correct alternative...CLOB's?
- Tim
http://www.phptemplates.org
- Original Message -
From: "Thies C. Arntzen" <[EMAIL PROTECTED]>
> > I
On Tue, Jun 26, 2001 at 06:42:00AM -0400, infoz wrote:
>
> If the data will be less than ~4K, use 'varchar2', otherwise use 'long'.
do not use long as long are not fully supported in oracle
(and never were).
tc
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-ma
On Mon, Jun 25, 2001 at 01:42:18PM -0500, Michael Champagne wrote:
> I'm developing a web application and would like to be able to store the state
> of the application in an Oracle table by serializing a bunch of variables and
> storing them in the database. Has anyone done this? What datatype w
In Oracle, 'long' is a variable-length character data column up to 2GB in
size. Roughly equivalent to 'text' in mysql, I think. You can also use
'blob', 'clob' and/or 'nclob' instead, but I think access to those types is
less straightforward than the 'long' type.
- Tim
http://www.phptemplate
Tim,
Thanks for the response. I'm kind of confused though. You can use a 'long'
type for a string of characters greater than 4k?
Thanks,
Mike
> If the data will be less than ~4K, use 'varchar2', otherwise use 'long'.
>
> - Tim
> http://www.phptemplates.org
>
> - Original Message -
>
If the data will be less than ~4K, use 'varchar2', otherwise use 'long'.
- Tim
http://www.phptemplates.org
- Original Message -
From: "Michael Champagne" <[EMAIL PROTECTED]>
To: "PHP General Mailing List" <[EMAIL PROTECTED]>
Sent: Monday, June 25, 2001 2:42 PM
Subject: [PHP] Help with
7 matches
Mail list logo