How to insert a DBCLOB data?

[chunglun]

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

[Sherman Lau]

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

"chunglun" <ch******@chunglun.com> wrote in message
news:87**************************@posting.google.c om...

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

[Sherman Lau]

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

"chunglun" <ch******@chunglun.com> wrote in message
news:87**************************@posting.google.c om...

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

[chunglun]

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

[chunglun]

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