[postgis-users] Unicode characters greater than 0x10000 errorinpostgresql

[Mark Cave-Ayland]

Hi MingMing,

 

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.

 

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.

 

 

Kind regards,

 

Mark.

------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023

http://www.webbased.co.uk  
http://www.infomapper.com
http://www.swtc.co.uk 

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.

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Mingming
Xu
Sent: 09 January 2006 05:33
To: Mark Cave-Ayland; Ming2 Xu
Cc: PostGIS Users Discussion
Subject: Re: [postgis-users] Unicode characters greater than 0x10000
errorinpostgresql

 

hi Mark and all, 

 

I installed the 8.1.1 version on Windows XP. 

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.  

 

ERROR: Invalid UTF-8 byte sequence detected near byte 0xb0
 

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. 

 

 

thanks

 

mingming 
 

On 7/25/05, Mark Cave-Ayland <m.cave-ayland at webbased.co.uk
<mailto:m.cave-ayland at webbased.co.uk> > wrote: 


> -----Original Message-----
> From: Mingming Xu [mailto: <mailto:ming2.xu at gmail.com>
ming2.xu at gmail.com]
> Sent: 25 July 2005 16:47
> To: Mark Cave-Ayland (External)
> Subject: Re: [postgis-users] Unicode characters greater than
> 0x10000 error inpostgresql
>
>
> Thanks Mark, 
>
> When is 8.1 scheduled to be releases?
>
> thanks
>
> Mingming


Hi Mingming,

A tentative release date has been set for this December; however it
generally depends on how many bugs are found during beta testing :) 

You can always download the latest versions from PostgreSQL CVS and PostGIS
CVS for testing, as strk as committed the changed required to run PostGIS
under PostgreSQL 8.1 CVS.


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Tamar Science Park
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023
W: http://www.webbased.co.uk  <http://www.webbased.co.uk> 



 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060109/ba164d89/attachment.html>