Problem, solved. This was my error from an incorrect role name used in the
connection string.
I'm confused about an error when accessing an FB3 database - "No permission for
USAGE access to Exception E_Exception".
When I run a program while logged into database as SYSDBA I do not get this
error.
I ran "grant usage on exception e_exception to user NICOLED" and "grant usage
on
I'm trying to get the field default value from
RDB$RELATIION_FIELDS.RDB$DEFAULT_VALUE which is stored as a BLOB type 2 -BLR.
Say I have a String or an Integer set as a default value, I don't know how to
read the BLOB BLR to get this value. I know it is possible since Database
Workbench
I got it. The search did not turn up anything initially for "default value",
but I searched again for RDB$DEFAULT_VALUE.
It is stored in RDB$DEFAULT_SOURCE
Thanks Mark,
I saw those collations, but they are for Spanish, French and Portugese.
All but a very small part of my DB will be in US-EN.
I added a column to a table with charset ISO8859_1 and collation ES_ES_CI_AI.
Indeed it was case insensitive for what I tried, however I'm not
I've used FB for years with ISO8859_1 charset and collation.
Now I designing a new DB for a big app update in FB3 and wonder about this
charset and collation.
For test purposes I am using UTF8 and UNICODE_AI_CI and I like that I can now
don't have to worry about casing comparisons nor
I've used FB for years with ISO8859_1 charset and collation.
Now I designing a new DB for a big app update in FB3 and wonder about this
charset and collation. My goal is to avoid having to UPPER everything for
comparison searches.
For test purposes I am using UTF8 and UNICODE_AI_CI and I