<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi MingMing,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>If the problem is with an INSERT or COPY
into a text/varchar field and still exists under PostgreSQL 8.1, then you would
need to email a test case to the PostgreSQL people – I would recommend
joining the pgsql-general list and sending an example of your command that
fails there.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Note there has been some mention on the
lists that PostgreSQL 8.0 did still allow certain illegal Unicode sequences to
enter the database which has been fixed in 8.1 (and so 8.1 will enforce
stricter checking), but one of the locale experts on the mailing lists will be
able to help you there.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Kind regards,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Mark.<o:p></o:p></span></font></p>
<div>
<p><font size=2 color=navy face="Times New Roman"><span style='font-size:10.0pt;
color:navy'>------------------------<br>
WebBased Ltd<br>
<st1:Street w:st="on"><st1:address w:st="on">17 Research Way</st1:address></st1:Street><br>
<st1:place w:st="on"><st1:City w:st="on">Plymouth</st1:City></st1:place><br>
PL6 8BT<br>
<br>
T: +44 (0)1752 797131<br>
F: +44 (0)1752 791023<br>
<br>
<a href="http://www.webbased.co.uk">http://www.webbased.co.uk</a> <br>
<a href="http://www.infomapper.com">http://www.infomapper.com</a><br>
<a href="http://www.swtc.co.uk">http://www.swtc.co.uk</a> <br>
<br>
This email and any attachments are confidential to the intended recipient and
may also be privileged. If you are not the intended recipient please delete it
from your system and notify the sender. You should not copy it or use it for
any purpose nor disclose or distribute its contents to any other person.</span></font><o:p></o:p></p>
</div>
<div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
postgis-users-bounces@postgis.refractions.net [mailto:postgis-users-bounces@postgis.refractions.net]
<b><span style='font-weight:bold'>On Behalf Of </span></b>Mingming Xu<br>
<b><span style='font-weight:bold'>Sent:</span></b> 09 January 2006 05:33<br>
<b><span style='font-weight:bold'>To:</span></b> Mark Cave-Ayland; Ming2 Xu<br>
<b><span style='font-weight:bold'>Cc:</span></b> <st1:PersonName w:st="on">PostGIS
Users Discussion</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [postgis-users]
Unicode characters greater than 0x10000 errorinpostgresql</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>hi Mark and all, <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I installed the 8.1.1 version on Windows XP. <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>My DB is created as encoding UTF-8. When I tried to enter
center Chinese character, I still getting error. I though the PostGreSQL
8.1 will solve this Unicode probelm for different language. <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><em><i><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>ERROR: Invalid UTF-8 byte sequence detected near byte
0xb0</span></font></i></em><br>
<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Any suggestion? Should I choose other encodings when I create the Db. I
did tried EUC-TW and several others, but the issue is still there. <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>thanks<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>mingming <br>
<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><span class=gmailquote><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>On 7/25/05, <b><span style='font-weight:bold'>Mark
Cave-Ayland</span></b> <<a href="mailto:m.cave-ayland@webbased.co.uk">m.cave-ayland@webbased.co.uk</a>>
wrote:</span></font></span> <o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
> -----Original Message-----<br>
> From: Mingming Xu [mailto:<a href="mailto:ming2.xu@gmail.com">
ming2.xu@gmail.com</a>]<br>
> Sent: 25 July 2005 16:47<br>
> To: Mark Cave-Ayland (External)<br>
> Subject: Re: [postgis-users] Unicode characters greater than<br>
> 0x10000 error inpostgresql<br>
><br>
><br>
> Thanks Mark, <br>
><br>
> When is 8.1 scheduled to be releases?<br>
><br>
> thanks<br>
><br>
> Mingming<br>
<br>
<br>
Hi Mingming,<br>
<br>
A tentative release date has been set for this December; however it<br>
generally depends on how many bugs are found during beta testing :) <br>
<br>
You can always download the latest versions from PostgreSQL CVS and PostGIS<br>
CVS for testing, as strk as committed the changed required to run PostGIS<br>
under PostgreSQL 8.1 CVS.<br>
<br>
<br>
Kind regards,<br>
<br>
Mark.<br>
<br>
------------------------<br>
WebBased Ltd<br>
<st1:Street w:st="on"><st1:address w:st="on">17 Research Way</st1:address></st1:Street><br>
<st1:place w:st="on"><st1:PlaceName w:st="on">Tamar</st1:PlaceName> <st1:PlaceName
w:st="on">Science</st1:PlaceName> <st1:PlaceType w:st="on">Park</st1:PlaceType></st1:place><br>
<st1:City w:st="on"><st1:place w:st="on">Plymouth</st1:place></st1:City><br>
PL6 8BT<br>
<br>
T: +44 (0)1752 797131<br>
F: +44 (0)1752 791023<br>
W: <a href="http://www.webbased.co.uk">http://www.webbased.co.uk </a><br>
<br>
<o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</div>
</body>
</html>