Re: Exception inserted value too large for column

From: Kamel Hamard <hamard_at_iro.umontreal.ca>
Date: Tue, 27 Jul 1999 02:00:46 GMT
Message-ID: <ip8n3.14317$8v6.710828@carnaval.risq.qc.ca>

Hi everybody,

Nicolas Bronke <news_at_TRINITY.de> wrote in message news:379c668c_at_news.uk.ibm.net...
>
> <sganesh_at_apple.com> schrieb in im Newsbeitrag: 379b5572_at_discussions...
> >
> > You can use
> > substr(string_in_hand,1,column_length) in that
> > insert.
> >

I already tried this solution, but I will not use it. The reason is: I want my applications independently of the databases. In the solution above, the column_length is hard coded.

> or let do them in the trigger before insert/before update
>

I am interested to this one. I already used substr in the trigger before insert, but as result I have always the exception, which I don't want to have! Any idea how to resolve it?

Thx for your help.

Kamel. Received on Mon Jul 26 1999 - 21:00:46 CDT