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]>
  2026-05-25 15:44 ` Re: Problem with encoding Thom Brown <[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:07 Problem with encoding Andrea Ricci <[email protected]>
@ 2026-05-25 15:44 ` Thom Brown <[email protected]>
  2026-05-25 16:39   ` Re: Problem with encoding 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 15:07 Problem with encoding Andrea Ricci <[email protected]>
  2026-05-25 15:44 ` Re: Problem with encoding Thom Brown <[email protected]>
@ 2026-05-25 16:39   ` Andrea Ricci <[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