Firebird: No connection charset when creating a new database
Posted: 26.01.2015, 21:02
Hello 
when creating a new database in Firebird with the parameter createNewDatabase the resulting connection will not be connected using the specified client chearacter set but it will use the character set NONE instead. This worked correctly in Zeos 6, which connected using the application specified client character set.
The reason for this is that Zeos 7.1 uses the connection that is created by the CreateNewDatabase procedure in ZDbcInterbase6.pas, which is created without a connection character set instead of disconnecting that connection and creating a new one where it is possible to specify the character set to use. Zeos 6 did exactly that. So the solution was simple: Reintroduce the code from Zeos 6.
I attached a patch that works for Zeos 7.1 and will supply another Patch for Zeos 7.2 if necessary later on.
With best regards,
Jan
when creating a new database in Firebird with the parameter createNewDatabase the resulting connection will not be connected using the specified client chearacter set but it will use the character set NONE instead. This worked correctly in Zeos 6, which connected using the application specified client character set.
The reason for this is that Zeos 7.1 uses the connection that is created by the CreateNewDatabase procedure in ZDbcInterbase6.pas, which is created without a connection character set instead of disconnecting that connection and creating a new one where it is possible to specify the character set to use. Zeos 6 did exactly that. So the solution was simple: Reintroduce the code from Zeos 6.
I attached a patch that works for Zeos 7.1 and will supply another Patch for Zeos 7.2 if necessary later on.
With best regards,
Jan