pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Encoding 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