DB2 CLOB datatype

[Pawe³ Krzaczkowski]

I'am trying to put a text file into a single database field. The txt file
has about 47000 letters (about 37 KB in txt format).

When i try to put it into CLOB field i get

SQL0102N The string constant beginning with "'Grzyby przez d³ugi czas
zaliczane by³y do królestwa ro¶lin. Karol Lin" is too long. SQLSTATE=54002

Here is the table i'm trying to put it into

create table test (
nr int,
text CLOB(2G) NOT LOGGED
)

The CLOB is declerated witch the max size (2G).
What is the max size of text that will fit into this field ?

I'm trying to migrate data from Mysql 4.0.12. The text fit's in mysql
without any problem as datatype "TEXT". What datatype field should i use for
that kind of data.

I'am using IBM DB2 UDB Express Edition.
--

Pawe³ Krzaczkowski
@ pk***********@tnp.pl
@ pa***@krzak.net