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: (view raw, whole thread or download thread mbox)
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 

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-2017 The PostgreSQL Global Development Group