[Cuis-dev] [ODBC] Using accented characters in resultset

[H. Hirzel]

Hi Olivier

A contribution towards an answer: yes it is an encoding issue.

If I use Notepad++

type

invité

(encoding is UTF8 there by default) and then choose ANSI in the 
'encoding' menu I get what you mention:

'invité'.

However how to do this in Cuis I have not yet managed to do. I guess 
there is a wayto tell the database driver that you want UTF8. That 
should actually be the default if things are fine.

--Hannes

On 29/12/2025 10:40 am, olivier auverlot via Cuis-dev wrote:
> Hi,
>
> I am trying to use the ODBC package for Cuis Smalltalk. I used the 
> documentation by Mark Volkmann 
> (https://mvolkmann.github.io/blog/topics/#/blog/smalltalk/50-databases/?v=1.1.1). 
> Thank you, Mark, for your tutorial!
>
> I'm connecting to a PostgreSQL database but I'm having an issue with 
> French accented characters. For example, instead of 'Invité', I get 
> the string 'invité'.
>
> I suspect an encoding issue, although I'm using the psqlodbcw.so 
> library which supports Unicode.
>
> Does anyone have experience with this ODBC package and can help me 
> resolve this issue?
>
> Best regards
> Olivier
>