RE: [PHP] Help with PHP/Oracle and serializing data

2001-06-26 Thread scott [gts]
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 >

Re: [PHP] Help with PHP/Oracle and serializing data

2001-06-26 Thread infoz
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

Re: [PHP] Help with PHP/Oracle and serializing data

2001-06-26 Thread Thies C. Arntzen
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

Re: [PHP] Help with PHP/Oracle and serializing data

2001-06-26 Thread Thies C. Arntzen
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

Re: [PHP] Help with PHP/Oracle and serializing data

2001-06-26 Thread infoz
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

Re: [PHP] Help with PHP/Oracle and serializing data

2001-06-26 Thread Michael Champagne
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 - >

Re: [PHP] Help with PHP/Oracle and serializing data

2001-06-26 Thread infoz
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