8 Apr
2010
8 Apr
'10
2:38 a.m.
Hi guys, I'm trying to insert data into a table of MonetDB from ODBC at windows platform. This is the definition of table, create table tbl1 (id int,dta clob); insert into tbl1 (id,dta) values(1,'[some thing]......') Here is the problem, If the length of [some thing] is bigger than 511, I can not get the entire result of "dta" from the table with sql sentence like "select * from tbl1". It would only return some part of the result(front part, like only 80 bytes. But it would work well if I insert data less than 511 bytes. Can anyone tell me how to deal with it? BTW, is there any way that I can use C# directly without ODBC? Thanks a lot. -- Best Regards, Xiao Lei