Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3FLCbu28367 for ; Sun, 15 Apr 2001 17:12:37 -0400 (EDT) (envelope-from pgsql-general-owner@postgresql.org) Received: from gl.aser.de (gl.aser.de [213.252.128.30]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3FHF7u86358; Sun, 15 Apr 2001 13:15:07 -0400 (EDT) (envelope-from gcg@gl.aser.de) Received: from pinguin (gcg@node100.dial.Uni-Magdeburg.DE [141.44.160.100]) by gl.aser.de (8.11.2/8.11.2/Debian 8.11.2-1) with SMTP id f3FHMtY05394; Sun, 15 Apr 2001 19:22:55 +0200 Content-Type: text/plain; charset="iso-8859-1" From: Christof Glaser Organization: gl.aser software engineering . internet service To: Maurizio Ortolan , pgsql-sql@postgresql.org Subject: Re: [SQL] How to simulate MEMO data type?Thanks! Date: Sun, 15 Apr 2001 19:24:00 +0200 X-Mailer: KMail [version 1.2] Cc: pgsql-general@postgresql.org References: <5.0.2.1.2.20010415101736.01e4c608@box.tin.it> In-Reply-To: <5.0.2.1.2.20010415101736.01e4c608@box.tin.it> MIME-Version: 1.0 Message-Id: <01041519240002.00850@pinguin> Content-Transfer-Encoding: 8bit X-Archive-Number: 200104/627 X-Sequence-Number: 7776 On Sunday, 15. April 2001 19:18, Maurizio Ortolan wrote: > Hello! > > I'm porting a database from MS Access > to PostgreSQL. Fine. Did you try the Access97-to-Postgres-7.1-Conversion Tool? Click here: http://www.sevainc.com/Access > How can I simulate in pgsql the 'MEMO' > (up to 65000 chars) data type, which > is often used in Access ? No need to simulate: just use type TEXT. > Where can I find an easy example? Browse the documentation: http://www.postgresql.org/users-lounge/ or read The Book: http://www.postgresql.org/docs/awbook.html > I don't' know if it's important, but > I'm using Linux,Apache,Javascript & > PHP. > ^^^ http://www.php.net Hope that helps, Christof -- gl.aser . software engineering . internet service http://gl.aser.de/ . Planckstraße 7 . D-39104 Magdeburg Tel. +49.391.7 44 77 10 . Fax +49.391.7 44 77 13 . Mobil 0177.77 92 84 3