pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCharacter codification
2+ messages / 2 participants
[nested] [flat]
* Character codification
@ 2006-12-21 14:30 Sistemas C.M.P. <sistemascmp@redynet4.com.ar>
2006-12-21 19:40 ` Re: Character codification Ivo Rossacher <rossacher@bluewin.ch>
0 siblings, 1 reply; 2+ messages in thread
From: Sistemas C.M.P. @ 2006-12-21 14:30 UTC (permalink / raw)
To: pgsql-admin
I'm using Linux server with postgres 8.0.2 and windows clients with VB aplications that using pgOleDB.dll and Libpq.dll.
The problem is:
Some user updates a record (with Text type field) with '?' character in this field
Then, when someone select this record the '?' characters appears like '$1'
This only happen with a few users. Not all
Thanks.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Character codification
2006-12-21 14:30 Character codification Sistemas C.M.P. <sistemascmp@redynet4.com.ar>
@ 2006-12-21 19:40 ` Ivo Rossacher <rossacher@bluewin.ch>
0 siblings, 0 replies; 2+ messages in thread
From: Ivo Rossacher @ 2006-12-21 19:40 UTC (permalink / raw)
To: pgsql-admin
There is an encoding which is used inside the server. Then the client can
specify what encoding the strings are he is sending. The server then
transforms the clientencoding to the internal representation. When the
described problem occurs this means that something in this process is not set
or wrong set. In the documentation you can find a list with supported
encodings and conversions in chapter 20 of the manual.
For me it did work best to take UTF8 as server encoding and specify the
correct client encoding within the initialisation of the database connection
(if required at all since most clients are UTF8 anyway).
If you need to fix the data already in the database you might use recode or
iconv on a text backup dump and restore the result.
Best regards
Ivo Rossacher
Am Donnerstag, 21. Dezember 2006 15.30 schrieb Sistemas C.M.P.:
> I'm using Linux server with postgres 8.0.2 and windows clients with VB
> aplications that using pgOleDB.dll and Libpq.dll. The problem is:
> Some user updates a record (with Text type field) with '?' character in
> this field Then, when someone select this record the '?' characters appears
> like '$1' This only happen with a few users. Not all
> Thanks.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-12-21 19:40 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-21 14:30 Character codification Sistemas C.M.P. <sistemascmp@redynet4.com.ar>
2006-12-21 19:40 ` Ivo Rossacher <rossacher@bluewin.ch>
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