German Umlaute GET / Unicode / SQL - QDBC - native

[Jimmy]

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

[nageswaragunupudi]

This problem is reported by another German user.
We are looking into this.

[nageswaragunupudi]

I found it working well with this following setup

Code: Select all  Expand view

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

Can you please check and confirm?

[Jimmy]

hi,

I found it working well with this following setup

Code: Select all  Expand view

  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 ?

[Jimmy]

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

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