pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedEncoding types
2+ messages / 2 participants
[nested] [flat]
* Encoding types
@ 2005-02-22 21:30 Patrick Meylemans <Patrick.Meylemans@wtcm.be>
0 siblings, 0 replies; 2+ messages in thread
From: Patrick Meylemans @ 2005-02-22 21:30 UTC (permalink / raw)
To: pgsql-admin
Dear,
I have the following problem :
On an win32 box (win2003 server) we selected as encoding SQL_ASII, we store
data into the tables with accents ... If we look at it with pgadminIII it
looks nice. From the cmd-prompt and via ODBC on the same box, the accents
are strange characters. Is we connect from another win32 box via ODBC the
accents are looking OK.
If we do the same on a Linux machine everything looks just fine
What do I mis ?
Kind Regards
Patrick Meylemans
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Encoding types
@ 2005-02-23 15:14 Magnus Hagander <mha@sollentuna.net>
0 siblings, 0 replies; 2+ messages in thread
From: Magnus Hagander @ 2005-02-23 15:14 UTC (permalink / raw)
To: Patrick Meylemans <Patrick.Meylemans@wtcm.be>; pgsql-admin
> Dear,
>
> I have the following problem :
>
> On an win32 box (win2003 server) we selected as encoding
> SQL_ASII, we store data into the tables with accents ... If
> we look at it with pgadminIII it looks nice. From the
> cmd-prompt and via ODBC on the same box, the accents are
> strange characters. Is we connect from another win32 box via
> ODBC the accents are looking OK.
>
> If we do the same on a Linux machine everything looks just fine
>
> What do I mis ?
SQL-ASCII means pg doesn't know anything about your accents. It will
serve up the characters with the same ASCII value they had when you put
them in.
Your problem comes from the command prompt using a different codepage
than the GUI on windows. A way to confirm this is to creaet a simple
textfile with one of these accents in it on your disk, and then do a
"type whatever.txt" to see it in the command prompt. You should see the
same disruptance.
For information on workarounds, see the "Notes for Windows users" on
http://www.postgresql.org/docs/8.0/static/app-psql.html. note that in
some cases it's enought o just change the font, in some cases you need
to do both steps.
//Magnus
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-02-23 15:14 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-22 21:30 Encoding types Patrick Meylemans <Patrick.Meylemans@wtcm.be>
2005-02-23 15:14 Re: Encoding types Magnus Hagander <mha@sollentuna.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox