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

[H. Hirzel]

Some more information:

If I paste an e acute symbol (accent and base character combined) from 
CharMap (see attachment)

é

into

https://codebeautify.org/utf8-converter

I get the two bytes representing the UTF8 version of the é
\xc3\xa9

Then if I use these two bytes and check out
https://www.alanwood.net/demos/ansi.html
I get in what you had
é

So it looks like that a correct sequence of UTF8 characters where 
interpreted as ANSI when reading the data from the database.

I would appreciate if updated version of the tutorial could be made 
available which deals with NON-ASCII characters.

On 30/12/2025 11:17 pm, H. Hirzel wrote:
> 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
>>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: CharMapWithEacute.gif
Type: image/gif
Size: 115150 bytes
Desc: not available
URL: <http://lists.cuis.st/mailman/archives/cuis-dev/attachments/20260102/54501100/attachment-0001.gif>