Re: Accented chars in several apps - Mailing list pgsql-general

From G. Brannon Smith
Subject Re: Accented chars in several apps
Date
Msg-id CLDdc.2528$zj3.715@newsread3.news.atl.earthlink.net
Whole thread Raw
In response to Accented chars in several apps  ("G. Brannon Smith" <brannonsmith@earthlink.net>)
Responses Re: Accented chars in several apps
List pgsql-general
Answering my own post. I went ahead and bit the bullent and dumped the
whole thing over to ENCODING = 'UNICODE'. Wasn't nearly as painful as I
thought it would be... although I guess the DB has now effectively
doubled in size.

G. Brannon Smith wrote:
> I have a personal database of my books, several of which are French with
> accented characters in their titles. However I am getting inconsistent
> display of the accent characters depending on the app I am using to
> access the DB.
>
> When the accents show up OK in psql and phpPgAdmin,
> they look like garbage in pgaccess and pgadmin3.
> If I correct them in pgaccess and/or pgadmin3,
> they look like garbage in psql and phpPgAdmin.
>



--
+--------------------------------------------------------------------+
| G. Brannon SMITH, M.S.         WWW: http://gbsmith.freeshell.org   |
|      Computer Science          mailto:gbsmithATfreeshellDOTorg     |
|                                mailto:brannonsmithATyahooDOTcom    |
+--------------------------------------------------------------------+
| "There is no off position on the genius switch." - David Letterman |
+--------------------------------------------------------------------+

pgsql-general by date:

Previous
From: mikecoxlinux@yahoo.com (Mike Cox)
Date:
Subject: Data Encryption in PostgreSQL, and a Tutorial.
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Data Encryption in PostgreSQL, and a Tutorial.