Re: Error with Clob

The column definition for VARCHAR(n) does not accept the shortcuts such
as 20M, but accepts 20000000 or other length values.

use VARCHAR(20725760) instead of VARCHAR(20M).

Fred

On Fri, Mar 22, 2013, at 17:37, Tmo_hsqldb_q wrote:
> Hi Fred
> 
> I might have misunderstood the point you made: "LONGVARCHAR is simply an
> alias for VARCHAR(16M)"
> I tried the following but get an error when creating the Trigger: 
> "unexpected token: 20M : line: 4 / Error Code: -5581 / State: 42581"
> 
> 
> CREATE TABLE testtable3 
> ( 
>    clobcolumn CLOB(20M)     NOT NULL 
> ); 
> 
> 
> CREATE TRIGGER testtable3_TRIG AFTER INSERT ON testtable3 
> referencing NEW ROW AS newrow 
> FOR EACH ROW WHEN (newrow.clobcolumn IS NOT NULL) 
> CALL testtableupdate3(CAST(newrow.clobcolumn AS VARCHAR(20M))); 
> 
> 
> 
> 
> --
> View this message in context:
> http://hsqldb.10974.n7.nabble.com/Error-with-Clob-tp151p3863.html
> Sent from the HSQLDB - User mailing list archive at Nabble.com.
> 
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_mar
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar