Hi, Dear all,

Below is a test done be me:

ij> create table lhf (luk char(10) for bit data);
0 rows inserted/updated/deleted
ij> connect 'jdbc:derby://nlsdev70.cn.ibm.com:1527/mydb;user=usr;password=pwd';
ij> insert into lhf values (X'05');
1 row inserted/updated/deleted
ij> insert into lhf values (X'5');
ERROR 42606: An invalid hexadecimal constant starting with 'X'5'' has been detec
ted.
ij> insert into lhf values (X'15');
1 row inserted/updated/deleted

Why the blue part can not work? Does it work as expected?

Thanks for your help!

Best Regards,
Haifeng
----------------------------------------------------------------------------------
WebSphere Information Integrator, IBM China Software Development Laboratory (CSDL)
Phone: 86-10-82782244 ext.3512 Fax: 86-10-82782244 ext.3251
Notes: Hai Feng Li/China/IBM E-mail: lihaif@cn.ibm.com
Address: 8/F, Bld.A, Ying Chuang, No.1, East Road, Shang Di, Beijing 100085, China
----------------------------------------------------------------------------------