It is intended to assist debugging of possible problems with legacy data when migrating a database from dialect 1 to 3. The precision for NUMERIC and DECIMAL data types is less than a dialect 3 database and if the precision is greater than 9, Firebird stores these as DOUBLE PRECISION.ĭialect 2 is available only on the Firebird client connection and cannot be set in the database. Options can be abbreviated to the unparenthesized charactersĭialect 1 stores date and time information in a DATE data type and has a TIMESTAMP data type which is identical to DATE.ĭouble quotes are used to delimit string data. w(rite) write synchronously or asynchronously u(se) use full or reserve space for versions tra(nsaction) shutdown transaction startup tw(o_phase) perform automated two-phase recovery pr(ompt) prompt for commit/rollback (-l) nol(inger) close database ignoring linger setting for it me(nd) prepare corrupt database for backup k(ill_shadow) kill all unavailable shadow files icu fix database to be usable with present ICU version fe(tch_password) fetch password from file fo(rce_shutdown) force database shutdown at(tach) shutdown new database attachments ac(tivate_shadow) activate shadow file for database usage Limbo Transaction Options - All The Same? New Startup and Shutdown States in Firebird 2.0 Database Housekeeping And Garbage Collection
0 Comments
Leave a Reply. |