fcl-db Interbase/Firebird connection doesn't use CharSet in .CreateDB call
Original Reporter info from Mantis: ggeldenhuys
-
Reporter name: Graeme Geldenhuys
Original Reporter info from Mantis: ggeldenhuys
- Reporter name: Graeme Geldenhuys
Description:
The TIBConnection.CreateDB method doesn't use the CharSet parameter when creating a database via code. So the only way to create a database with a default character set is to create one manually via Interbase/Firebird isql tool.
The attached patch (interbase.patch) resolves this issue. Below is the output from isql showing the issue.
--------[ before the patch ]--------------
SQL> show database;
Database: localhost:/home/graemeg/programming/data/m2.fdb
Owner: SYSDBA
PAGE_SIZE 4096
Number of DB pages allocated = 412
Sweep interval = 20000
Forced Writes are OFF
Transaction - oldest = 328
Transaction - oldest active = 329
Transaction - oldest snapshot = 329
Transaction - Next = 332
ODS = 11.1
Default Character set: NONE
--------------------------[ end ]------------------------
--------[ after the patch is applied ]--------------
SQL> show database;
Database: localhost:/home/graemeg/programming/data/m2.fdb
Owner: SYSDBA
PAGE_SIZE 4096
Number of DB pages allocated = 407
Sweep interval = 20000
Forced Writes are OFF
Transaction - oldest = 11
Transaction - oldest active = 12
Transaction - oldest snapshot = 12
Transaction - Next = 15
ODS = 11.1
Default Character set: UTF8
--------------------------[ end ]------------------------
Mantis conversion info:
- Mantis ID: 13835
- OS: Ubuntu Linux
- OS Build: 7.10
- Platform: x86
- Version: 2.3.1
- Fixed in version: 2.4.0
- Fixed in revision: 13386 (#735b0cd2)
- Target version: 2.4.0