topic-43473

Board index FiveWin for Harbour/xHarbour German Umlaute GET / Unicode / SQL - QDBC - native

Posts: 1772

Joined: Thu Sep 05, 2019 05:32 AM

German Umlaute GET / Unicode / SQL - QDBC - native
Posted: Tue Jul 18, 2023 08:39 PM

hi,

i have Problem with GET when type German "Umlaute"
it work fine with DBF (where i can set Codepage) but fail SQL - QDBC - native

i have use "latest" Access Sample (with FWH 23/04)
https://forums.fivetechsupport.com/viewtopic.php?f=3&t=43466

i type : "aaa" and than "ä" but when type 2nd "ä" i got this

it also happens using TPQServer() or "native" using LibPQ.DLL for PostgreSQL

greeting,

Jimmy

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: German Umlaute GET / Unicode / SQL - QDBC - native
Posted: Tue Jul 18, 2023 09:08 PM

This problem is reported by another German user.

We are looking into this.

Regards

G. N. Rao.

Hyderabad, India

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: German Umlaute GET / Unicode / SQL - QDBC - native
Posted: Wed Jul 19, 2023 04:00 PM

I found it working well with this following setup

Code (fw): Select all Collapse

   HB_LANGSELECT( "DE" )
   HB_CDPSELECT( "DEWIN" )
   FW_SetUnicode( .F. )

Can you please check and confirm?

Regards

G. N. Rao.

Hyderabad, India

Jimmy

Posts: 1772

Joined: Thu Sep 05, 2019 05:32 AM

Re: German Umlaute GET / Unicode / SQL - QDBC - native
Posted: Wed Jul 19, 2023 09:33 PM

hi,

nageswaragunupudi wrote:I found it working well with this following setup
Code (fw): Select all Collapse
   HB_LANGSELECT( "DE" )
   HB_CDPSELECT( "DEWIN" )
   FW_SetUnicode( .F. )
Can you please check and confirm?

thx for Answer

i can now "input" German Umlaute
... but not working with PostgreSQL Server, which use UTF8, when want to "save" it :(

Question : do you use ANSI for ADO / ODBC or UTF8 ?

greeting,

Jimmy

Jimmy

Posts: 1772

Joined: Thu Sep 05, 2019 05:32 AM

Re: German Umlaute GET / Unicode / SQL - QDBC - native
Posted: Thu Jul 20, 2023 04:32 AM

hi,

have try Sample c:\fwh\samples\pgre01.prg
using PostgreSQL v9.5 Server and WIN1252 for Database

now i can "input", even German Umlaute, and "save" it :D

on same Server i try UTF8 Table but than it fail again ...
so i need to use ANSI Table for Fivewin Sample

greeting,

Jimmy

FiveTech Support Forums

Continue the discussion