[fpc-devel] TField.AsString and Databases with UTF-8 charset

[Michael Van Canneyt]

On Tue, 21 Jul 2009, Graeme Geldenhuys wrote:

> Michael Van Canneyt wrote:
>> 
>> Which means firebird reports 8 to your application.
>
> So does this issue only occur on my system and not on others? Do you uses 
> charset=UTF8 in your databases, and Firebird reports the correct size for 
> Char() fields?

I never use Char fields, and I also don't use charsets in Firebird...

> I'll put together a small test case and sample Firebird database so I can 
> rule out tiOPF as a possible cause. I'll also double check using different 
> database components. I have SqlDB, FBLib and IBX (from Delphi 7) available 
> here.

IBX will present problems; I had problems with field sizes when using IBX and 
Delphi 7 and firebird 2.1, which seems to use UTF-8 for metadata.
It might be interesting to see how they solved the problem in later Delphis.

Michael.