Zeoslib Portal

Hello Delphidreamer, the case did not let me sleep. It seems that the DBC-Driver for Interbase and firebird did not always return the correct string type. I have created a patch that lets me save normal latin letters, russian letters and even chinese words in one field. The patch is created against ...

No, I say have a database that is Unicode (UTF8) and an application that is Delphi 7 + Zeos 6, which is ANSI, which uses codepages. Add the CODEPAGE=xxx parameter to your connection object - depending on the locale settings of windows. You could the codepage from an ini file or try to determine it p...

Hello Delphidreamer, I did some short tests using Delphi XE, Zeos 7 and a Firebird 2.1 Database using WIN1252 as the default character set encoding. For me it seems that there are problems in Zeos 7 that prevent all this to work correctly. In my setup, using CODEPAGE=WIN1252 will lead to a correctly...

Hello delphidreamer, your problem seems to be different. For (VAR)CHAR fields Firebird does the transliteration automatically, if you set the connection character set correctly. If you use Firebird 2.1 with its new ODS, you will also get an automated transliteration for BLOBs of sub type text (= sub...

I am sorry for the delay. I was really busy at work... I think testing for the Server Version would not be that hard. I am sure there is some API call to get the version. I am sure that it is possible to gather the required information when operating from a result set. But I think it is also valid f...

Hello Mark, the code is against the 6.6 code because I wanted it to work in Delphi 6 and Lazarus. If a solution for the general problem can be found I am willing to port the necessary changes to 7.0. The aim was to enable Zeos to automatically request firebird to do character set conversion for text...

You read the manual more carful than I did. I only found the way to create a Blob Parameter Buffer (BPB) and give that to isc_open_blob2 and isc_create_blob2. So far I have managed to create a BPB for all cases where a blob is read but have trouble when it comes to writing because there seems to be ...

Hello seawolf and mdaems, thanks for your answer. According to the Interbase 6 documentation you can ask Firebird to transliterate blobs of subtype text when you open them or create them by giving the needed information to isc_open_blob2 or isc_create_blob2. The Zeos Interbase / Firebird driver does...

Hello, I try to access a firebird database from Lazarus where some fields contain umlauts. The default character set of the database is WIN1252. To get the transliteration to UTF8, which is used by Lazarus, done correctly by firebird, I add the line "CODEPAGE=UTF8" to ZConnection.Propertie...

Hello seawolf,

the problem seems to be gone - most probably due to an update of Lazarus...
Thanks for your help,

Jan

Hello, I try to read the Firebird system tables to be able to copy the structure of an existing database. In Delphi 6 everything works as expected. But in Lazarus I get an exception "Cannot transliterate character between character sets." It does not matter wether I set the codepage to UTF...

Hello sfxcc, as far as I understand firebird, sweeping is not for actually shrinking the size of the database file. Sweeping checks the internal DB structures for outdated records and marks the space they occupy to be usable again. This way the engine can reuse the space for newly inserted records. ...

Hello josimarz, this is the main problem: locate is very slow when there are large datasets (20000+ rows). It makes no difference if the dataset is sorted and i do the locate for the sorted columns. I assume that TZQuery is doing a linear search in any case. Using a binary search algorithm is fast. ...

Hello Josimar, I am sorry for the long delay it took me to answer. I had to modify your code because my test data consists of 65000 rows. I also added a check for comparing the ID-Field to make sure that the bookmark still belongs to the same row. So this is the code that I tested: var BookMark: Str...

Hello josimarz, thank you for your help. Unfortunately this does not work too. I get the same error at the same element. When I remove the line [font=Courier New]ZQuery1.SortedFields := '';[/font] everything works fine. So unsorting ZQuery1 must be changing the bookmarks for some records. Best regar...