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

Michael Van Canneyt michael at freepascal.org
Fri Jul 24 15:59:49 CEST 2009



On Fri, 24 Jul 2009, Martin Schreiber wrote:

> On Friday 24 July 2009 14:06:21 Graeme Geldenhuys wrote:
>
>> PostgreSQL also supports the UTF-8 character set in databases. Surprise,
>> surprise TParam.Size and TField.Size report the value of Char(x). Also
>> the return values read from the Char(x) field don't contain any space
>> padding on the right unless the actual text is less than the Char(x)
>> definition. Also the character length NEVER exceeds the Char(x) definition.
>>
> Try to enter 'äöüéà' in a char(5) utf-8 encoded PQ field in SqlDb. ;-)

I see Martin understood since long what I was trying to say :-)

Michael.


More information about the fpc-devel mailing list