Thread: another stupid question
Hi, I am still having problems to move from mysql. Am I missing something about "text" columns? I seem not to be able to retrieve them (using php) just like varchar or ... ones. btw. I could not find out how much I can put inside a text field! Maybe all this has something to do with my general not-yet-understanding of LO's??? I thank you now in advance for your help! Alex -- ___________________________ Alexander Lohse Human Touch Medienproduktion GmbH Am See 1 17440 Klein Jasedow Tel: (038374) 75211 Fax: (038374) 75223 eMail: al@humantouch.de http://www.humantouch.de
On Wed, 4 Apr 2001 01:43:25 +0200, Alexander Lohse alluded: > Am I missing something about "text" columns? > > I seem not to be able to retrieve them (using php) just like varchar > or ... ones. A simple example: jeff=# CREATE TABLE test( jeff(# id INTEGER, jeff(# stuff TEXT); CREATE jeff=# INSERT INTO test VALUES(42, 'Something'); INSERT 64908 1 jeff=# SELECT * FROM test; id | stuff ----+----------- 42 | Something (1 row) I cannot attest for PHP usage: post to the pgsql-php list for that. > btw. I could not find out how much I can put inside a text field! For version 7.1 there is no longet a limit on the length of field of type 'text'. Jeff -- Jeff Duffy jeff@alanne.com
>On Wed, 4 Apr 2001 01:43:25 +0200, Alexander Lohse alluded: > >> Am I missing something about "text" columns? >> >> I seem not to be able to retrieve them (using php) just like varchar > > or ... ones. > >A simple example: > >jeff=# CREATE TABLE test( >jeff(# id INTEGER, >jeff(# stuff TEXT); >CREATE > >jeff=# INSERT INTO test VALUES(42, 'Something'); >INSERT 64908 1 > >jeff=# SELECT * FROM test; > id | stuff >----+----------- > 42 | Something >(1 row) Hi, that is exactly me! Then I need to search on different corners for the problem here! Thank you, anyway! Regards, Alex -- ___________________________ Alexander Lohse Human Touch Medienproduktion GmbH Am See 1 17440 Klein Jasedow Tel: (038374) 75211 Fax: (038374) 75223 eMail: al@humantouch.de http://www.humantouch.de