Re: [firebird-support] Is it save to append some data at end of the binary firebird database file?

2015-12-04 Thread Fabiano Kureck fabi...@sci10.com.br [firebird-support]

What you can do is inspect Firebird structure and search for an unused area.
Documentation about this can be found at
http://www.firebirdsql.org/manual/fb-internals.html

By example if you check
http://www.firebirdsql.org/manual/fbint-standard-header.html

Pag_checksum: Two bytes, unsigned. Bytes 0x02 - 0x03. Checksum for the 
whole page. No longer used, always 12345, 0x3039. Databases using ODS8 
on Windows NT do have a valid checksum here.


You can use this safely (?)

Em 03/12/2015 22:19, Christian Gütter n...@guetter.org 
[firebird-support] escreveu:



Mark Rotteveel wrote:

> On Windows, all files can have alternative streams with additional
> data. It is a form of hidden metadata that is attached to the main 
filename.


True, but the alternate data streams get lost when the file is stored
on a non-NTFS drive, sent via FTP/E-Mail etc. So depending on how the
software of the OP is released, this might not work well.

Anyway, rereading the original post, I realized that he is looking for
a platform independent solution, so my focus on Windows did not help
anyway.

Cheers,
Christian




--


Re: [firebird-support] Upgrade from 2.5.2 to 2.5.4

2015-11-06 Thread Fabiano Kureck fabi...@sci10.com.br [firebird-support]

No.
Only from 2.5.1 to another version.

Em 05/11/2015 22:21, todd.brass...@yahoo.com [firebird-support] escreveu:


Is a Backup and Restore Required?







Re: [firebird-support] Cannot Create Index

2015-10-13 Thread Fabiano Kureck fabi...@sci10.com.br [firebird-support]
Maximum key size is one quarter of page size. What is your database page 
size? What is the collation of that field?

Try increase database page size to 16Kb

Em 13/10/2015 12:20, Vishal Tiwari vishuals...@yahoo.co.in 
[firebird-support] escreveu:

Hi All,

I am trying to create index on a field which is of data type 
Varchar(255) using FlameRobin, while committing I get below error message:


key size exceeds implementation restriction for index "IDX_"


How do I create an index on a field which is of data type Varchar(255) ?

Thanks In Advance.

With Best Regards.

Vishal