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

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

2001-06-26 Thread Sebastian Stadtlich
D]] > Gesendet: Dienstag, 26. Juni 2001 12:42 > An: Michael Champagne; PHP General Mailing List > Betreff: Re: [PHP] Help with PHP/Oracle and serializing data > > > > If the data will be less than ~4K, use 'varchar2', otherwise > use 'long'. > > -

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
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 PHP/Oracle and serializing data &

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

2001-06-26 Thread infoz
t: Monday, June 25, 2001 2:42 PM Subject: [PHP] Help with PHP/Oracle and serializing data > 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

[PHP] Help with PHP/Oracle and serializing data

2001-06-25 Thread Michael Champagne
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 would be best to use here? I'm not serializing too much data now, but oth