[patch_done] Problems with accentuation Lazarus 2.7.1

The alpha/beta tester's forum for ZeosLib 7.0.x series

Report problems concerning our Delphi 2009+ version and new Zeoslib 7.0 features here.

This is a forum that will be removed once the 7.X version goes into stable!!

Moderators: gto, EgonHugeist, olehs

elidorio2
Expert Boarder
Expert Boarder
Posts: 159
Joined: 20.08.2006, 05:37
Location: Tapejara -Pr
Contact:

[patch_done] Problems with accentuation Lazarus 2.7.1

Postby elidorio2 » 05.09.2012, 02:59

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

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1701
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 05.09.2012, 03:08

elidorio2,

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

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

elidorio2
Expert Boarder
Expert Boarder
Posts: 159
Joined: 20.08.2006, 05:37
Location: Tapejara -Pr
Contact:

Postby elidorio2 » 05.09.2012, 03:28

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

elidorio2
Expert Boarder
Expert Boarder
Posts: 159
Joined: 20.08.2006, 05:37
Location: Tapejara -Pr
Contact:

Postby elidorio2 » 09.09.2012, 03:53

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

Edson

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1701
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 09.09.2012, 07:59

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...........
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

elidorio2
Expert Boarder
Expert Boarder
Posts: 159
Joined: 20.08.2006, 05:37
Location: Tapejara -Pr
Contact:

Postby elidorio2 » 15.09.2012, 21:53

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

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1701
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 16.09.2012, 15:59

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...
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

elidorio2
Expert Boarder
Expert Boarder
Posts: 159
Joined: 20.08.2006, 05:37
Location: Tapejara -Pr
Contact:

Postby elidorio2 » 24.09.2012, 00:03

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

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1701
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 24.09.2012, 11:46

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?
You do not have the required permissions to view the files attached to this post.
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

elidorio2
Expert Boarder
Expert Boarder
Posts: 159
Joined: 20.08.2006, 05:37
Location: Tapejara -Pr
Contact:

Postby elidorio2 » 24.09.2012, 14:18

Good morning Michael,

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

Edson

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1701
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 24.09.2012, 16:45

elidorio2,

where can i download a FPC2.7.1?
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

elidorio2
Expert Boarder
Expert Boarder
Posts: 159
Joined: 20.08.2006, 05:37
Location: Tapejara -Pr
Contact:

Postby elidorio2 » 24.09.2012, 17:41


User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1701
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 24.09.2012, 20:05

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..
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

elidorio2
Expert Boarder
Expert Boarder
Posts: 159
Joined: 20.08.2006, 05:37
Location: Tapejara -Pr
Contact:

Postby elidorio2 » 26.09.2012, 15:17

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

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

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1701
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 26.09.2012, 16:51

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..
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image


Return to “ZeosLib 7.0 Beta Forum”

Who is online

Users browsing this forum: No registered users and 1 guest