Subject | Re: OCTETS as binary (and another problem with CachedRowSetImpl) |
---|---|
Author | Fabiano |
Post date | 2012-07-19T14:11:11Z |
Here is the script to create and populate the table used in the test:
recreate table test (
id char(16) character set octets not null collate octets);
insert into test values (
ascii_char(65) ||
ascii_char(66) ||
ascii_char(67) ||
ascii_char(00) ||
ascii_char(65) ||
ascii_char(66) ||
ascii_char(67) ||
ascii_char(00) ||
ascii_char(65) ||
ascii_char(66) ||
ascii_char(67) ||
ascii_char(00) ||
ascii_char(65) ||
ascii_char(66) ||
ascii_char(67) ||
ascii_char(00));
Regards,
Fabiano
recreate table test (
id char(16) character set octets not null collate octets);
insert into test values (
ascii_char(65) ||
ascii_char(66) ||
ascii_char(67) ||
ascii_char(00) ||
ascii_char(65) ||
ascii_char(66) ||
ascii_char(67) ||
ascii_char(00) ||
ascii_char(65) ||
ascii_char(66) ||
ascii_char(67) ||
ascii_char(00) ||
ascii_char(65) ||
ascii_char(66) ||
ascii_char(67) ||
ascii_char(00));
Regards,
Fabiano