By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,821 Members | 1,075 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,821 IT Pros & Developers. It's quick & easy.

Accented chars in several apps

P: n/a
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.

An example:
pgadmin3 shows
[Paris, Odéon-Théâtre de France, 21 Octobre 1963] ; (suivi de) Pas
Moi : [Paris, Théâtre d'Orsay, 8 Avril 1975]

while phpPgAdmin renders
[Paris, Odon-Thtre de France, 21 Octobre 1963] ; (suivi de) Pas Moi :
[Paris, Thtre d'Orsay, 8 Avril 1975]

-OR- (same database, diff row)
psql (SQL_ASCII enc) has
la dissertation fran?aise aux baccalaur?ats et aux concours

but pgadmin3 sez
la dissertation franaise aux baccalaurats et aux concours

(dunno how these will travel in email)
The bookcat database is SQL_ASCII. Initdb initted the system (7.4.2
installed by RPM on Fedora Core 1) as en_US.UTF-8.

What should I be checking for in these apps and how can I make them ALL
consistently render the accents correctly?

--
+--------------------------------------------------------------------+
| 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 |
+--------------------------------------------------------------------+
Nov 23 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
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 |
+--------------------------------------------------------------------+
Nov 23 '05 #2

P: n/a
Am Freitag, 9. April 2004 22:32 schrieb G. Brannon Smith:
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.


Isn't Unicode mostly the same size in byte as long as most charcters are
ascii? So, are you sure your DB size doubles? in my understanding of unicode,
size should be almost the same in your case.

kind regards,
janning

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.