Subject Re: [firebird-support] UTF8 in Blob, subtype Text & IBObjects
Author Lester Caine
Martijn Tonies wrote:
>>>> I think that text draw problem, not IBO core(or API) problem.
>>>> This case become correct result with e.g. TMS unicode controls.
>>>> It will be possible if unicode controls or ExtTextOutW API.. are used.
>>>>
>>> However, on VARCHAR it works just fine, so what's the deal here?
>>>
>> Sorry, i have mistaken. The german umlaute are BMP in UCS2(ansi range).
>>
>>> Additional Information
>>>
>> As far as i understanding in IB_components.pas,
>> The ansi decoding is only string type. (Please see
>>
> SetAsString/GetAsString)
>
>> The transliteraion of BLOB type may be necessity...
>>
>
> But how do these characters for VARCHAR get displayed then? I have
> a test table here, with two columns, one is the varchar and one is the
> blob subtype text, I insert the same values in both. Varchar is displayed
> just fine, while the blob isn't.
>
Martijn - I'm getting behind the times nowadays, but is this simply a
matter that while the BLOB type may say TEXT, the software does not have
that information, so has to treat BLOB as raw binary? VARCHAR is text
and has a flag for the character set?

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php