Zeoslib Portal

I use a search where the case statement, to display the value of the column case, it shows the value in dbgrig. The Zeos shows the value as memo. follows the SQL command below. select a.cd_fil,a.cd_titulo,a.no_doc,a.no_origem, case when a.fg_tipo_pgto = 'DIN' then 'Dinheiro' when a.fg_tipo_pgto = 'C...

Hi Michael and Alexs,

The problem is solved.

Thank you,


Note: We need to warn the FPC forum that the problem was solved.

Edson

already gone through this problem, two possible solution

- Create a path from the bin folder of the environment variables in postgresql
- Install the vcredist_x64.exe that the installer of postgresql.

Hello Michael,

One thing I still can not understand!!
From what i understand the problem in this FPC is not?
The encoded strings that SQLdb and Zeos uses is not the same?
Because SQLDB saves correct and Zeos not ?
Please excuse my doubt, I could not understand. Please check ezemplo.zip

Edson

ok,
I still have another suggestion I'll post soon.

Hello Michael,

I'm embarrassed to not know anything about developing components.
The only thing I can do is report a bug or submit a suggestion ....
Excuse me.

Edson

It would be possible to implement in Zeos, the screen RESULT of SQL, has the same SQLdb.
I find it very interesting in horar create the sql already able to do the test mesmo.Segue attached mode

Edson

Hello Michael,
I created a small example with Zeos and SQLDB, saved in the database the same information. With SQLDB saved normal and Zeos occurred the same problem with the accent.
Attached examples.
Edson

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

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

This address

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

Edson

Good morning Michael,

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

Edson

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

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

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

Edson

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