<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi<br>
When I look at the message source, I see content-encoding set to UTF-8<br>
When I created the message, I set the content to UTF-8,<br>
What Thunderbird or the mail list do with it after that I cant say<br>
I can confirm that your mail was UTF-8, base64 encoded<br>
<br>
I have had loads of problems with database encoding & transfer of
data, though I didn't expect the same with these mails<br>
This thread clearly demonstrates to the reader what goes wrong when
encoding standards change & the potential pitfalls when changing
Lazarus to UTF-8<br>
Mattias is Absolutely right about the encoding, yet Thunderbird tells
me the encoding is UTF-8<br>
This brings me back to the original point about database encoding<br>
If you use UTF-8 in the Lazarus application, ensure that your database
driver speaks UTF-8 & your tables are also using UTF-8<br>
Anything else & your risking data mangling & seeing
???????????????? or some other junk where your text should be<br>
<br>
Mattias Gaertner wrote:
<blockquote cite="mid:20080724025608.52118b84@limapholos" type="cite">
<pre wrap="">On Thu, 24 Jul 2008 01:48:52 +0200
Mattias Gaertner <a class="moz-txt-link-rfc2396E"
href="mailto:nc-gaertnma@netcologne.de"><nc-gaertnma@netcologne.de></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On Thu, 24 Jul 2008 00:23:36 +0100
Ivan Gan <a class="moz-txt-link-rfc2396E"
href="mailto:ivan@comchatter.com"><ivan@comchatter.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap="">No. It's iso-8859-1 and the ???? are just plain ascii.
</pre>
</blockquote>
<pre wrap=""><!---->
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
<a class="moz-txt-link-abbreviated"
href="mailto:Lazarus@lazarus.freepascal.org">Lazarus@lazarus.freepascal.org</a>
<a class="moz-txt-link-freetext"
href="http://www.lazarus.freepascal.org/mailman/listinfo/lazarus">http://www.lazarus.freepascal.org/mailman/listinfo/lazarus</a>
</pre>
</blockquote>
</body>
</html>