Subject How to create a string column with significant trailing spaces
Author Thekla Damaschke
There is a difference in behaviour between firebird and most other RDBMS
regarding string columns.
It seems like firebird ALWAYS ignores trailing spaces in string fields
when matching,
while other vendors distinguish between CHAR and VARCHAR fields here,
where VARCHAR fields are not padded automatically.
I have a usecase where I would like to declare a database column without
i.e. the selections "WHERE col = 'xyz' " does NOT deliver rows with col
= 'xyz ',
while otherwise preserving the normal collation properties , like
sorting order and similar.

Is there a way to achieve this inside the database server without an
application level tricks ?
Thanks for any hints.
/Thekla Damaschke