Hi,
I tried to convert binary blob field to varchar column in select statement but
It did not work.
Here is what I did:
1. I created a domain
CREATE DOMAIN D_BIGVARCHAR AS
VARCHAR(32000) CHARACTER SET OCTETS
COLLATE OCTETS;
Then when I use this query
select cast(JOB_INFO as
On Feb 9, 2015, at 11:52 AM, 'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support] firebird-support@yahoogroups.com wrote:
What is your cache settings
[2048]
Zoran's complaint is about the first time the query is executed. In that
case, nothing would be in cache and
I'm having problems shutting down a databases on the server.
I have followed the instructions in the documentation:
http://www.firebirdsql.org/manual/gfix-dbstartstop.html
And by using the following command the database seems to be shut down:
gfix -user SYSDBA -pas masterkey -shut full -force
Ann,
Zoran's complaint is about the first time the query is executed. In that
case, nothing would be in cache and everything would still need to be loaded
from disk.
A 2048 page cache may be small enough that it would cause problems even
during loading, given the size of his database and
And by using the following command the database seems to be shut down:
gfix -user SYSDBA -pas masterkey -shut full -force 0 C:\Database\MyDB.fdb
Why isn’t this command working properly and what can I do to shut down
the database so that I can rename it (in order to restore a backup).