[Lazarus] Unicode and DBAware

Ivan Gan ivan at comchatter.com
Thu Jul 24 11:16:22 CEST 2008

When I look at the message source, I see content-encoding set to UTF-8
When I created the message, I set the content to UTF-8,
What Thunderbird or the mail list do with it after that I cant say
I can confirm that your mail was UTF-8, base64 encoded

I have had loads of problems with database encoding & transfer of data, 
though I didn't expect the same with these mails
This thread clearly demonstrates to the reader what goes wrong when 
encoding standards change & the potential pitfalls when changing Lazarus 
to UTF-8
Mattias is Absolutely right about the encoding, yet Thunderbird tells me 
the encoding is UTF-8
This brings me back to the original point about database encoding
If you use UTF-8 in the Lazarus application, ensure that your database 
driver speaks UTF-8 & your tables are also using UTF-8
Anything else & your risking data mangling & seeing ???????????????? or 
some other junk where your text should be

Mattias Gaertner wrote:
> On Thu, 24 Jul 2008 01:48:52 +0200
> Mattias Gaertner <nc-gaertnma at netcologne.de> wrote:
>> On Thu, 24 Jul 2008 00:23:36 +0100
>> Ivan Gan <ivan at comchatter.com> wrote:
>>> Hi
>>> Be warned that this will fail on some databases
>>> Example, ZEOS components, Lazarus 0.9.25 Unicode UTF-8, database 
>>> encoding UTF-8
>>> Tables contain ansi & extended including Chinese & Hebrew
>>> If you fail to set the driver to UTF-8, the transliteration is done 
>>> before the table object receives it
>>> The result is ????? instead of Chinese & Hebrew
>>> This email is utf8 encoded & the following lines are supplied as a
>>> test reference
>> No. It's iso-8859-1 and the ???? are just plain ascii.
> The html part of them mail is also iso-8859-1 but the characters
> are html encoded. In the html view you can see the characters.
> But there was no UTF-8 in the mail.
> Here is UTF-8:
> Hebrew : אתר זה משתמש בטכנולוגיה NLSO
> Chinese : 这个网页使用自然语文支持物体科技
> English : This site uses NLSO technology
> Polish : Ta strona używa technologi NLSO
> Mattias
> _______________________________________________
> Lazarus mailing list
> Lazarus at lazarus.freepascal.org
> http://www.lazarus.freepascal.org/mailman/listinfo/lazarus
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20080724/5f1a5983/attachment-0007.html>

More information about the Lazarus mailing list