. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 4.1. Why row IDs at all? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.1. What is this article about? This article explains what Firebird generators are, and how and why you should use them. It is an attempt to collect all relevant information about generators in a single versions 32767 In InterBase versions prior to 6, generators were only 32 bits wide. This explains why these older versions could store roughly twice the number of generators on the same page size. 

|| NULL • MyField = NULL • MyField <> NULL • NULL = NULL If you have difficulty understanding why, remember that NULL means “unknown”. You can also look at the following table where per-case explanations applications don’t do this. After all, if the server assures you that a column can’t contain NULLs, why would you think you know better, override the server’s decision and check for NULLs anyway? And yet tell me that its cosine is 1! Although the history of these functions is known and we can understand why they behave like they do (see User-Defined Functions (UDFs)�), it’s still wrong. Incorrect results

commercial versions of the product). There are others, but the last two are ones that I have used myself. Why doesn’t Firebird provide encryption? Because of the needs described above it is common for users to Obscurity 13 Chapter 9. The Philosophical Argument There is also the philosophical question of why you would choose an open source database server product to build a closed source database. Many people

Understanding the mechanism for storing and retrieving fixed-point data should help to visualise why: for storage, the number is multiplied by 10 s (10 to the power of s), converting it to an integer; || NULL MyField = NULL MyField <> NULL NULL = NULL not (NULL) If it seems difficult to understand why, remember that NULL is a state that stands for “unknown”. NULL in Logical Expressions It has already plugin, the maximum password length is 255 characters, for an effective length of 20 bytes (see also Why is the effective password length of SRP 20 bytes?). For the Legacy_UserManager plugin only the first

Appendix A: Setting up a Firebird 1.5 Release Candidate Before you read this appendix, ask yourself why you are working with an RC. If it's not for any special reason, but just because it “happens to be

command cannot complete in the specified time, the shutdown is aborted. There are various reasons why the shutdown may not complete in the given time, and these vary with the mode of the shutdown and

will be installed. • It is assumed that: 1. you understand how your network works 2. you understand why a client/server system needs both a server and clients Installing on Windows 17 3. you have read

Understanding the mechanism for storing and retrieving fixed-point data should help to visualise why: for storage, the number is multiplied by 10 s (10 to the power of s), Chapter 3. Data Types and || NULL MyField = NULL MyField <> NULL NULL = NULL not (NULL) If it seems difficult to understand why, remember that NULL is a state that stands for “unknown”. NULL in Logical Expressions It has already are populated with data only at the moment when the user queries them. That is also one good reason why it is no use trying to create triggers for them! The key notion in understanding the monitoring feature

starts off with a standard page header. The pag_flags byte is used on these pages. The bits used and why are: Bit 0 set means do not garbage collect this page. Bit 1 set means this page is not propogated