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

> The SQL dialect of the database is 3.
> The database default character set is ASCII,
> the varchar column has a character set id of 2 and
> that the blob column in question has a character set id of 2 as well.

"2" is the ID of character set "ASCII". Anytime you insert some non
ASCII charcters into such a column, you should get an error. Yes,
often Word is the offender: smart quotes, hyphens of different length etc.

Actually, Firebird does this checking in a sloppy way, and the wrong
characters are only detected, when a character set conversion is
involved. If you give FB a string to store in an ASCII column, and
your app (or DB access layer) tells FB it's an ASCII string, no checks
are done.

But I'm not sure about the BLOB issues here, and we should wait for
Helen's response, how the BLOB fits into this scenario.

Regards,
Peter Jacobi