2010/6/9 svanderclock <svanderclock@...>

> 3/ If i create the field like this CHAR(1) CHARACTER SET OCTETS NOT NULL COLLATE OCTETS does it's matter if i set Charset=ISO8859_1 on the connection client ? or i absolutelly need to set Charset=OCTECTS on the connection clients ? (because i will need to do SQL like where Myfield < xxx or > yyy)

of course you can connect with Charset=ISO8859_1

but if you wanted to store binary values inside your CHAR(1) OCTETS
field use the x'' notation

cf release notes
http://www.firebirdsql.org/devel/doc/rlsnotes/html/rlsnotes25.html#rnfb25-dml-hex