Search found 16 matches

by pawelp
01.03.2012, 15:01
Forum: PostgreSQL
Topic: Working with UTF8 encoded dbs
Replies: 15
Views: 5315

ok, why not.
Can you put me to a place where I can find how to download that build and how to contact the author?
by pawelp
21.02.2012, 18:28
Forum: PostgreSQL
Topic: Working with UTF8 encoded dbs
Replies: 15
Views: 5315

The problem is, I do not know what this charackters are and in which table and columd they appear. It is like a small corruption inside the db :) Like I said, this is most probably caused by the legacy data beeing imported by different means. The only solution would be to advise the db somehow to el...
by pawelp
21.02.2012, 11:58
Forum: PostgreSQL
Topic: Working with UTF8 encoded dbs
Replies: 15
Views: 5315

Some customers have legacy databases, either imported from xls, access or mysql. The problem do not occur on all of them. But maybe on 10%. The program is old and large, the dB structure and the dB access changed during the lifetime of the application. I assume, the characters that do not have a WIN...
by pawelp
20.02.2012, 16:55
Forum: PostgreSQL
Topic: Working with UTF8 encoded dbs
Replies: 15
Views: 5315

My customers are from germany, that why I use WIN1252. I think that is the proper one for germany, is it not?

I will try to move some parts of the code to a newer version of delphi.
But how stable is Zeos 7? It is still in alpha state, right?
by pawelp
14.02.2012, 13:56
Forum: PostgreSQL
Topic: Working with UTF8 encoded dbs
Replies: 15
Views: 5315

I tried to set the codepage to WIN1252.
It works fine. But... sometimes I got the error, that a unicode charackter as no equivalent in WIN1252. That is a SQL Error reported by postgres.
Maybe if there were a way to change that behavior from raising an error to be just a warrning...
by pawelp
13.02.2012, 16:22
Forum: PostgreSQL
Topic: Working with UTF8 encoded dbs
Replies: 15
Views: 5315

Is Zeus 7 stable enough
If so I could upgrade
But for some time I'm stuck with delphi 2007.
But maybe I will be able to move some parts of the project to delphi 2010 if that is the only solution
by pawelp
12.02.2012, 15:50
Forum: PostgreSQL
Topic: Working with UTF8 encoded dbs
Replies: 15
Views: 5315

Working with UTF8 encoded dbs

I have a postgres 8.3 Database which is encoded in UTF8. I'm using Zeos 6.6.6 Before connecting, I'm setting the connection properties like that ZConn.Properties.Values['codepage']:='UTF8'; ZConn.Properties.Values['client_encoding']:='UTF8'; // now, when I execute a SQL Query, I got the following er...
by pawelp
20.01.2010, 01:22
Forum: 6.6 - stable
Topic: Cancelling a Query running in a thread
Replies: 7
Views: 1028

One small thing so far:
GetIZPlainDriver is undeclared identifier.
But I found the proc GetDriver. I suppose that's the one.
by pawelp
20.01.2010, 00:38
Forum: 6.6 - stable
Topic: Cancelling a Query running in a thread
Replies: 7
Views: 1028

thanks, I will try it out
by pawelp
19.01.2010, 14:39
Forum: 6.6 - stable
Topic: Cancelling a Query running in a thread
Replies: 7
Views: 1028

I'm using Postgres 8.3.9. ZeosLib 6.6.6-stable (from 2009-12-30). Delphi 2007.
by pawelp
19.01.2010, 04:53
Forum: 6.6 - stable
Topic: Cancelling a Query running in a thread
Replies: 7
Views: 1028

Cancelling a Query running in a thread

Hi all, how can I cancel a Zquery, which is opening in an other thread? The Query opens some quite huge amount of data, which is displayed afterwards in a Grid. I perform the Zquery.open call inside a separate thread, so my main Form will not be frozen. But, the user can close this form while the th...
by pawelp
26.11.2008, 20:01
Forum: 6.6 - stable
Topic: TZQuery is read-only when using stored procedure in SQL
Replies: 4
Views: 699

I have a similar Problem, but my sql Query is a Join one and looks something like this: SELECT "car"."idnt" AS "Indicator", "car"."cnumer" AS "customer_numer", (...) "customer"."numer" AS "customernnumer", &quo...
by pawelp
30.08.2008, 01:16
Forum: 6.6 - stable
Topic: How to Handle AutoIncs (or SERIALS in Postgres)
Replies: 3
Views: 749

How to Handle AutoIncs (or SERIALS in Postgres)

Halo, I'm using TClientDataset, TDatasetProvider and TZQuery. I have a postgreSQL database with a simple table with a field called id of type SERIAl and a field 'name' of type varchar(20). I fould an article "How to use AutoInc fields with DataSnap" (http://dn.codegear.com/kr/article/20847...
by pawelp
22.08.2008, 10:01
Forum: 6.6 - stable
Topic: Problem with GetTableNames and Postgre
Replies: 6
Views: 1449

Yes. Pawel is a quite common name here in Poland :) Mark, I think this is a good solution. And about the "PG dummy", this isn't something you should be sorry about. Anyone is an expert in some fields and a dummy in other fields :) And we all (or at least the most of us) always do learn som...
by pawelp
21.08.2008, 08:22
Forum: 6.6 - stable
Topic: Problem with GetTableNames and Postgre
Replies: 6
Views: 1449

Gum' at first, many thanks for that quick help, great work. I think its better if the GetTableNames methode returns just table names, per default. If you need sequences, you can use the new overloaded version to specify them. But IMHO most users will use the GetTableNames to build some kind of admin...