Subject | RE: [ib-support] FB crash |
---|---|
Author | Szakály Balázs |
Post date | 2002-05-07T17:30:33Z |
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]
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]