[patch_done] Problems with accentuation Lazarus 2.7.1

[elidorio2]

Problems with accentuation Lazarus 2.7.1 and Zeos.
Words with accents is recorded in the database wrong.
Would anyone ever had this problem with Lazarus 2.7.1?

Edson

[EgonHugeist]

elidorio2,

only with fpc2.7.1? Could you please write allways the protocol you are using? So which one do you use?

[elidorio2]

Sorry, pfc 2.7.1
I am using Postgresql with protocol and: postgresql-8

[elidorio2]

Hello Michael,
This problem also occurs fpc, Lazarus 2.6.1 and 1.1.

Edson

[EgonHugeist]

elidorio2,

Hi Edson. Can you make me a BugTemplate? I must admit we run tests for that and everything seems ok. I need much more Details like the Zeos Client Characterset and this one of the Server...........

[elidorio2]

Michael,

What is the difference in using the protocol postgresql and postgresql-8-9?
When I auditioned with fpf 2.7.1 was using postgresql-8 protocol.
Currently I am using postgresql 9.2.

Edson

[EgonHugeist]

elidorio2,

What is the difference in using the protocol postgresql and postgresql-8-9?

It's just the name and one changed CodePage which you as FPC user can't see...

Edson, give me more details...

[elidorio2]

Hello Michael,
Sorry for the delay, this time short these days!!
Come, my environment is as follows:
Postgresql: 9.2
FPC: 2.7.1
Zeos 7: 7.0.0-dev rev. in 1847
CodePage: UTF8
Protocol: postgresql-9

By typing the word GENÊRICO 2 appears thus: GENÊRICO 2

What might be happening?

Edson

[EgonHugeist]

elidorio2,

I'll check it with FPC2.6 question are these values returned from the Database like 'GENÊRICO 2' or are the written wrong into the database?

see attachement tested with FPC2.6.0 LCL1.0RC2 are you sure it happens with FPC2.6.0 too? Really?

For FPC2.7.1 i have an idea what could be the reason: UTF8Encode(..): RawByteString instead of AnsiString. The do use codepages now and i had trouble for this case with D12_UP too.

Edson can you please test it with FPC2.6 again?

[elidorio2]

Good morning Michael,

With this fpc 2.6 normal, the problem with this fpc 2.7.1.

Edson

[EgonHugeist]

elidorio2,

where can i download a FPC2.7.1?

[elidorio2]

This address

ftp://freepascal.dfmk.hu/pub/lazarus/snapshots/

Edson

[EgonHugeist]

elidorio2,

ok Edson. Issue confirmed. BUT the ?double? encoded values do come from the FPC-DataSet/Lazarus.
Well for the first: don't use this compiler for production. It might be possible this issue is gone except in this snapshots. I've debugged the strings and here is not Zeos the problem. I know about some users like LudoB which have no such issues but i can't say which build of FPC/LCL he uses.

For that case i propose to use the stable candidates. You can ask for help on the FPC Forums, Edson.

What happens if you use th TPQConnection? I got allways a lot of Exception if i use this Components..

[elidorio2]

Hello Michael,
registered a bug in fpc, see their response.

http://bugs.freepascal.org/view.php?id=22982

[EgonHugeist]

elidorio2,

Well Edson, i've added a comment too. It might be helpfull if you make a little sample Project and attach it. So they can confirm the issue and see what can be done..