Search Postgresql Archives

Re: Accented chars in several apps

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux