Hello,
I believe the following behavior to be a bug:
create table tinyint_test ( mycol tinyint );
insert into tinyint_test values (128);
select * from tinyint_test;
The select yields "-128" - looks like we
overflowed storage; perhaps
using byte instead of short?
I believe the TINYINT type should handle an 8-bit integer
value
between 0 and 255 (signed or unsigned)
Rob Manning
P.S. For your "Other software that supports Mckoi
SQL" section, there is the
SQuirreL SQL Client (ht
tp://www.squirrelsql.org/index.php?page=faq#faq0)
------------------------------------------------------------
---
Mckoi SQL Database mailing list http://www.mckoi.com/d
atabase/
To unsubscribe, send a message to mckoidb-unsubscribe mckoi.com
|