Hi
I tried making a table
create table test (number int, mytext clob)

and tried inserting a tuple into it
insert into test(number, mytext) values( 4, 'lalala')

my problem is that it seems mytext is padded cause when I do a
select * from test where number = 4
I get a LOT of blank lines before it tells me there was 1 record selected.

Can anyone help me out with this padding issue
I dont want to use varchar because i dont know exactly how much space i'm going to need - trying to make a message board. CLOB is the closest thing i can get to a text datatype (from MySQL)

You can use RTRIM function ...

But, remember to increase dbm cfg UDF_MEM_SZ

db2 update dbm cfg using UDF_MEM_SZ 1024

1024 is just an example
HTH

Sathyaram