Re: varchar to text - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: varchar to text
Date
Msg-id 20051002124344.GD30492@svana.org
Whole thread Raw
In response to varchar to text  (Zlatko Matić <zlatko.matic1@sb.t-com.hr>)
List pgsql-general
On Sun, Oct 02, 2005 at 11:37:10AM +0200, Zlatko Mati? wrote:
> There are some columns in my tables that I should change from varchar to text, in order to have enough space for long
textualcommentaries.  
> Before I do that, I would like to know is there any restriction regarding text type in comparison to varchar type?
> Especially concerning triggers and rules ?
> Namely, I have triggers that perform audit trail of all my tables, so I'm concerned whether it will work for text
typefields ? 

The varchar type is text plus restrictions. So no, switching to text
lets you do more, not less...

> One additional question is regarding my MS Access front-end. Would it be a problem for Access ?

The ODBC driver has something like "map text to memo". Make sure that's
off, otherwise access won't let you do comparisons on it.

Hope this helps,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: scoring differences between bitmasks
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Broken pipe