Re: [PHP] Help with PHP/Oracle and serializing data
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 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 anyone done this? What datatype would be best to use here? I'm not serializing too much data now, but other applications that we do in the future may. Would this be a place to use a CLOB or should I stick with varchar2? Thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Help with PHP/Oracle and serializing data
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 - 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 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 other applications that we do in the future may. Would this be a place to use a CLOB or should I stick with varchar2? Thanks! -- Michael Champagne, Software Engineer Capital Institutional Services, Inc. wk: [EMAIL PROTECTED] hm: [EMAIL PROTECTED] ** This communication is for informational purposes only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction, unless specifically agreed otherwise. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect the views or opinions of Capital Institutional Services, Inc. Capital Institutional Services, Inc. accepts no liability for any errors or omissions arising as a result of transmission. Use of this communication by other than intended recipients is prohibited. ** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Help with PHP/Oracle and serializing data
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.phptemplates.org Thanks for the response. I'm kind of confused though. You can use a 'long' type for a string of characters greater than 4k? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Help with PHP/Oracle and serializing data
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 would be best to use here? I'm not serializing too much data now, but other applications that we do in the future may. Would this be a place to use a CLOB or should I stick with varchar2? Thanks! depending on the size - i would use CLOB. tc -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
AW: [PHP] Help with PHP/Oracle and serializing data
NO NO NO NO NO NO NO NO NEVER use long varchar2 for 4k or clob for longer does long still exist in oracle9 i thought it is supposed to be left out ( as soon as possible ) to your question at first : why don't you try to overwrite the php session handling funktions? serialisation is done by them and you need just to save in db look here : http://www.phpbuilder.net/columns/ying2602.php3 i always wanted to do that, but newer did... if you make it code snipplets are welcome :-] sebastian -Ursprüngliche Nachricht- Von: infoz [mailto:[EMAIL PROTECTED]] 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'. - 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 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 anyone done this? What datatype would be best to use here? I'm not serializing too much data now, but other applications that we do in the future may. Would this be a place to use a CLOB or should I stick with varchar2? Thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Help with PHP/Oracle and serializing data
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-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Help with PHP/Oracle and serializing data
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] 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-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Help with PHP/Oracle and serializing data
with MySQL, TEXT is for text and BLOB is for binary data. typemax. storage size TINYBLOB, TINYTEXT 2^8 BLOB, TEXT 2^16 MEDIUMBLOB, MEDIUMTEXT 2^24 LONGBLOB, LONGTEXT 2^32 -Original Message- From: infoz [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 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.phptemplates.org Thanks for the response. I'm kind of confused though. You can use a 'long' type for a string of characters greater than 4k? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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 anyone done this? What datatype would be best to use here? I'm not serializing too much data now, but other applications that we do in the future may. Would this be a place to use a CLOB or should I stick with varchar2? Thanks! -- Michael Champagne, Software Engineer Capital Institutional Services, Inc. wk: [EMAIL PROTECTED] hm: [EMAIL PROTECTED] ** This communication is for informational purposes only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction, unless specifically agreed otherwise. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect the views or opinions of Capital Institutional Services, Inc. Capital Institutional Services, Inc. accepts no liability for any errors or omissions arising as a result of transmission. Use of this communication by other than intended recipients is prohibited. ** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]