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 |
+--------------------------------------------------------------------+