How to insert a DBCLOB data?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chunglun - 03 May 2004 03:55 GMT

Hi,

I am inserted a record into a table that contains a DBCLOB field, the
record is successfully added after executing the statement except that
the DBCLOB field has inserted nothing. I have tried all the followings
for the DBCLOB field:

'sample'
n'sample'
g'sample'

all of them returned nothing for the field of the new record. Could
anyone please give me some idea on it?

The version of DB2 I am using is ESE UDB 8.1.5, thanks!

Chunglun

Reply to this Message

Sherman Lau - 03 May 2004 14:42 GMT

What is the codeset of your database?

GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC and DBCLOB are defined to store pure
double-byte characters.
'sample' are 6 single byte characters. If you are using non-Unicode database
and the code pages of your set up are different, your input, 'sample' will
be replaced as subsitution characters after code page conversion. Therefore
when you select the data back, the row shows empty character. g'sample'
should be fine if you are using non single byte characters.

Sherman

> Hi,
>
[quoted text clipped - 13 lines]
>
> Chunglun

Reply to this Message

chunglun - 04 May 2004 03:46 GMT

Thanks! Sherman

For my case, I am using .NET (ASP.NET with Server Side program
developed in C#) connecting DB2. The database codeset is already
utf-8, and the code pages I set up also in utf-8. Still, I can't
insert the data I want properly, why is it so?

Chunglun

Reply to this Message