[GENERAL] Error size varchar

2003-10-29 Thread Edwin Quijada
Hi!! I got error about a length field varchar. I have a table with a field type varchar(20) but if I try to set to this field more than 20 characters I got error. I did a function to control the length of data and put it on trigger but when it ocurrs I got the error anyway and the trigger

Re: [GENERAL] Error size varchar

2003-10-29 Thread Edwin Quijada
*---* From: Tom Lane [EMAIL PROTECTED] To: Edwin Quijada [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: [GENERAL] Error size varchar Date: Wed, 29 Oct 2003 11:28:23 -0500 Edwin Quijada [EMAIL PROTECTED] writes: I got error about a length field varchar. I have a table with a field type

Re: [GENERAL] Error size varchar

2003-10-29 Thread Adam Kavan
At 05:06 PM 10/29/03 +, Edwin Quijada wrote: wHAT IS unconstrained varchar??? Define the column as just varchar. This allows a string of any length. Then have a trigger truncate it after it is inserted. --- Adam Kavan --- [EMAIL PROTECTED] ---(end of

Re: [GENERAL] Error size varchar

2003-10-29 Thread Tom Lane
Edwin Quijada [EMAIL PROTECTED] writes: I got error about a length field varchar. I have a table with a field type varchar(20) but if I try to set to this field more than 20 characters I got error. I did a function to control the length of data and put it on trigger but when it ocurrs I