Setting value for DB2 varchar for bit data column

Question

In a DB2 database on Windows, I have a table with a column of data type 'varchar for bit data'. I insert a record in this table, and set a value for this column. When I select the record after that, I see a different value for this column then the value I set in the insert statement. It is obviously being converted implicitly. The value I want to see in this column when I select this record is '38E2C310275B6A8F7E966E9B529741BC'. Which value do I use in my insert statement to achieve this?

Thanks for helping me out.

mao · Accepted Answer · 2021-06-18 15:30:54Z

1

create table fbd ( a varchar(32) for bit data)

insert into fbd(a) values X'38E2C310275B6A8F7E966E9B529741BC'

select a from fbd

A                                                                  
-------------------------------------------------------------------
x'38E2C310275B6A8F7E966E9B529741BC'                                



select hex(a) from fbd

1                                                               
----------------------------------------------------------------
38E2C310275B6A8F7E966E9B529741BC

answered Jun 18, 2021 at 15:30

mao

12.4k2 gold badges15 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Raf Van Camp Over a year ago

Thanks mao. That is exaclty what I was looking for.

Collectives™ on Stack Overflow

Setting value for DB2 varchar for bit data column

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related