>> I wonder why I don't see this problem at all with varchar columns
>> though. If I change the char(1) to varchar(1), everything works
>> properly and I don't seem to have to do any of this. Is this expected?
>
> I assume with varchar, FB trims the buffer to the data size actually used?

That's strange, why shouldn't it do this with the CHAR datatype? Apparently,
it "knows" how many characters equals a certain number of bytes.


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com