| From: | "G(dot) Brannon Smith" <brannonsmith(at)earthlink(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Accented chars in several apps |
| Date: | 2004-04-09 20:32:34 |
| Message-ID: | CLDdc.2528$zj3.715@newsread3.news.atl.earthlink.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 |
+--------------------------------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2004-04-10 00:35:17 | Re: Data Encryption in PostgreSQL, and a Tutorial. |
| Previous Message | Mike Cox | 2004-04-09 20:31:38 | Data Encryption in PostgreSQL, and a Tutorial. |