Thread: Apostrophe doesn't show up in command line
In a field I have text like "in today's news..." When I select that field in psql using putty (Latin-1), then apostrophe doesn't show up (shows up as "todays"), but it does show up in phppgadmin (and other php programs). Is this an issue with psql, or putty (or something else)? Thanks, CSN ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs
CSN wrote: > In a field I have text like "in today's news..." When > I select that field in psql using putty (Latin-1), > then apostrophe doesn't show up (shows up as > "todays"), but it does show up in phppgadmin (and > other php programs). Is this an issue with psql, or > putty (or something else)? It's an issue with your character-set settings somwhere along the line. This sort of thing can be a real pain - you'll need to check every component involved. Start at the Windows/putty end, and check what character set phppgadmin is using (HINT: is it utf-8?) -- Richard Huxton Archonet Ltd
--- Richard Huxton <dev@archonet.com> wrote: > CSN wrote: > > In a field I have text like "in today's news..." > When > > I select that field in psql using putty (Latin-1), > > then apostrophe doesn't show up (shows up as > > "todays"), but it does show up in phppgadmin (and > > other php programs). Is this an issue with psql, > or > > putty (or something else)? > > It's an issue with your character-set settings > somwhere along the line. > This sort of thing can be a real pain - you'll need > to check every > component involved. Start at the Windows/putty end, > and check what > character set phppgadmin is using (HINT: is it > utf-8?) Hmm, how can you tell? I don't see character set specified anywhere in phppgadmin (including conf.inc.php). CSN __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
CSN wrote: >>and check what >>character set phppgadmin is using (HINT: is it >>utf-8?) > > > Hmm, how can you tell? I don't see character set > specified anywhere in phppgadmin (including > conf.inc.php). View > Character Encoding in firefox while you have a page open View > Encoding in IE -- Richard Huxton Archonet Ltd
Ah, it's Western ISO-8859-1. Putty has the same setting. I tried changing putty's charset to UTF-8 and now curly apostrophes are displayed as a grey box in psql's output (e.g. "in today[box]s news..."). Thanks, CSN --- Richard Huxton <dev@archonet.com> wrote: > CSN wrote: > >>and check what > >>character set phppgadmin is using (HINT: is it > >>utf-8?) > > > > > > Hmm, how can you tell? I don't see character set > > specified anywhere in phppgadmin (including > > conf.inc.php). > > View > Character Encoding in firefox while you have > a page open > View > Encoding in IE > > -- > Richard Huxton > Archonet Ltd > ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs