--- In firebird-support@yahoogroups.com, "Salvatore Besso" wrote:

> SELECT ID_A FROM TABLE_A WHERE NAME = 'ABC683'
>
> and with big surprise this is the result:
>
> ID_A NAME
> -----------------
> 1 ABC68
> 2 ABC683

Are you working with charset NONE or are specific
charset and collation set for NAME?

Please extract full DDL. (show table TABLE_A;)

Regards,
Peter Jacobi