Skip site navigation (1) Skip section navigation (2)

storing and working with accented characters (high ascii)

From: Diana Nemirovsky <diana(at)marinconsulting(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: storing and working with accented characters (high ascii)
Date: 2005-07-26 05:29:05
Message-ID: 6.0.1.1.2.20050725191516.02b25898@marinconsulting.com (view raw or flat)
Thread:
Lists: pgsql-novice
I have a person table, and some of the records have accented characters, 
such as accent-e. My trigger is choking on the character with the error 
message "ERROR:  invalid byte sequence for encoding "UNICODE": 0xe2b365". 
If I edit the field to remove that accented e, no problem. What is the 
proper way to handle this? I read on google references to utf encoding 
etc., but they were not complete explanations and I'm still confused. It 
seems I need to use the convert command, but I haven't found an useful 
example. Anyone have one? How does this impact ORDER BY commands, for 
example? And if I'm outputting this data to an RTF file, how does that work 
with Mac OS vs. Windows for example, where the ascii codes are different 
for the same accented e (following my example). Any insights or helpful 
links are appreciated.

As always, thanks.



Diana Nemirovsky
Marin Consulting, Inc.
770 Menlo Ave, Ste 223
Menlo Park, CA 94025
v (650) 617-8699
f (650) 833-0790
http://www.marinconsulting.com 




pgsql-novice by date

Next:From: Mogin MohandasDate: 2005-07-26 06:49:07
Subject: creating a new data type
Previous:From: Michael FuhrDate: 2005-07-26 02:46:27
Subject: Re: Importing dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group