public inbox for [email protected]help / color / mirror / Atom feed
Problem with encoding 3+ messages / 2 participants [nested] [flat]
* Problem with encoding @ 2026-05-25 15:07 Andrea Ricci <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Andrea Ricci @ 2026-05-25 15:07 UTC (permalink / raw) To: pgsql-odbc Hi, I'm using Powerbuilder via ODBC on a PostgreSQL 17 database (13.02.00.00 ANSI). The setting of server encoding is 'UTF8', and in the "Connect Setting" parameter of ODBC voice I have "SET CLIENT_ENCODING TO 'UTF8'". The problem appears when I attempt to update a char(4) column with '4· ' (34 B7 20 20 in hex)vor similar value with "high" characters, via explicit sql instruction. The same update instruction via pgAdmin works, of course. Thanks in advance A -- Attachments: [image/png] Immagine.png (30.1K, 3-Immagine.png) download | view image ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Problem with encoding @ 2026-05-25 15:44 Thom Brown <[email protected]> parent: Andrea Ricci <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Thom Brown @ 2026-05-25 15:44 UTC (permalink / raw) To: Andrea Ricci <[email protected]>; +Cc: pgsql-odbc On Mon, 25 May 2026, 16:07 Andrea Ricci, <[email protected]> wrote: > Hi, > > I'm using Powerbuilder via ODBC on a PostgreSQL 17 database (13.02.00.00 > ANSI). > > The setting of server encoding is 'UTF8', and in the "Connect Setting" > parameter of ODBC voice I have "SET CLIENT_ENCODING TO 'UTF8'". > > The problem appears when I attempt to update a char(4) column with '4· ' > (34 B7 20 20 in hex)vor similar value with "high" characters, via explicit > sql instruction. > The same update instruction via pgAdmin works, of course. > You are using an ANSI driver, which won't work with what you are sending, particularly because it includes what appears to be a multibyte character (that dot in the middle). Do you have a unicode driver available? Thom > > Attachments: [image/png] Immagine.png (30.1K, 3-Immagine.png) download | view image ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Problem with encoding @ 2026-05-25 16:39 Andrea Ricci <[email protected]> parent: Thom Brown <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Andrea Ricci @ 2026-05-25 16:39 UTC (permalink / raw) To: Thom Brown <[email protected]>; +Cc: pgsql-odbc Yep ! That was the problem, actually using an *UNICODE* driver, everything works thanks A Il 25/05/2026 17:44, Thom Brown ha scritto: > > *CAUTION* - This e-mail originates outside of Dedalus. Be vigilant > with content, links and attachments! > > On Mon, 25 May 2026, 16:07 Andrea Ricci, <[email protected]> wrote: > > Hi, > > I'm using Powerbuilder via ODBC on a PostgreSQL 17 database > (13.02.00.00 ANSI). > > The setting of server encoding is 'UTF8', and in the "Connect > Setting" parameter of ODBC voice I have "SET CLIENT_ENCODING TO > 'UTF8'". > > The problem appears when I attempt to update a char(4) column with > '4· ' (34 B7 20 20 in hex)vor similar value with "high" > characters, via explicit sql instruction. > The same update instruction via pgAdmin works, of course. > > > You are using an ANSI driver, which won't work with what you are > sending, particularly because it includes what appears to be a > multibyte character (that dot in the middle). > > Do you have a unicode driver available? > > Thom > > -- Attachments: [image/png] Immagine.png (30.1K, 3-Immagine.png) download | view image ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2026-05-25 16:39 UTC | newest] Thread overview: 3+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-05-25 15:07 Problem with encoding Andrea Ricci <[email protected]> 2026-05-25 15:44 ` Thom Brown <[email protected]> 2026-05-25 16:39 ` Andrea Ricci <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox