Subject RE: [ib-support] FB crash
Author Szakály Balázs
Hi!

Three questions:
1. What is your page size? Is it large enough to accommodate one
record?


Page size is 8K. I think, this large is enought.
- BIN_DATA max: 600char, BIN_WORK max 300char length -> 1 char=3byte? or
not? -> 900*3byte=2700 byte
- 38 integer field = 4byte*38 -> 152 byte
- 9 datetime field = 8byte?*9 -> 72 byte
so, max 3000byte real data is 1 record + one index



2. Are you using the proper version of the gds client on all of the
client
machines?


This is a local only system. It use DBExpress. The lastest.


3. Is it coincidence that the column names of your two large varchar
columns is BIN_* ? Are you trying to poke binary data into character
containers?


This fields contain binary datas, that are first compress with zip, and
encode with a specific code64 algoritm with this chars:
const CodeList:
string[64]='+-0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuv
wxyz';
I now check, that the BIN_* fields contain only this chars.






4. Connect string?

On the DBExpress, i cannot see the connect string. Only properties:

BlobSize=-1
CommitRetain=False
LocaleCode=0000
SQLDialect=3
Interbase TransIsolation=ReadCommited
ServerCharSet=WIN1250
Database=127.0.0.1:c:\aaa\wa.gdb
User_Name=SYSDBA
Password=masterkey





[Non-text portions of this message have been removed]