Re: Problem with too short column

On Wed, 4 Feb 2004 Thomas(dot)AUBRY(at)limagrain(dot)com wrote:

> Hi,
>
> I actually try to insert varchar which length is higher than 32 in a column
> which type is varchar(32). I can't change the type of the column, and I
> want to trunc the data. I know it's possible ! I have seen this !
>
> Example : "j'aime les saucisses avec du beurre dedans" will be "j'aime les
> saucisses avec du beu". For the moment it produces a SQL Error !
>
> Is it an option in the config files ?

Note that in my previous posting I think I used substring with a 0 start,
it should start at 1:

select substring('abcdefgh',1,4);
SELECT
substring
----
abcd