Subject | Brookstone again |
---|---|
Author | Salvatore Besso |
Post date | 2005-02-25T15:26:21Z |
hello all,
I have followed the hint of copying fbintl.dll to gdsintl.dll (both are now in
the INTL folder) and I have stopped and restarted the server.
Then, I have created a fresh database and I have inserted the desired collation
into it as per instructions (I need only this collation):
DELETE FROM RDB$COLLATIONS
WHERE RDB$COLLATION_NAME = 'BETA_ISO8859_1_NOCASE'
AND RDB$CHARACTER_SET_ID = 21
AND RDB$COLLATION_ID = 16;
INSERT INTO RDB$COLLATIONS(
RDB$COLLATION_NAME,
RDB$CHARACTER_SET_ID,
RDB$COLLATION_ID)
VALUES('BETA_ISO8859_1_NOCASE', 21, 16);
But as soon as I try to create a table with a field that uses this collation,
for example:
SET NAMES ISO8859_1;
...
CREATE DOMAIN INT_ID
AS INTEGER
NOT NULL
CHECK(VALUE > 0);
CREATE DOMAIN CH_DB_VERSION
AS VARCHAR(10)
NOT NULL
COLLATE BETA_ISO8859_1_NOCASE;
CREATE TABLE DB_Versions(
ID_Version INT_ID,
DB_Version CH_DB_VERSION);
I get an error that says:
This operation is not defined for system tables.
Unsuccessful metadata update.
What am I doing wrong?
Regards
Salvatore
I have followed the hint of copying fbintl.dll to gdsintl.dll (both are now in
the INTL folder) and I have stopped and restarted the server.
Then, I have created a fresh database and I have inserted the desired collation
into it as per instructions (I need only this collation):
DELETE FROM RDB$COLLATIONS
WHERE RDB$COLLATION_NAME = 'BETA_ISO8859_1_NOCASE'
AND RDB$CHARACTER_SET_ID = 21
AND RDB$COLLATION_ID = 16;
INSERT INTO RDB$COLLATIONS(
RDB$COLLATION_NAME,
RDB$CHARACTER_SET_ID,
RDB$COLLATION_ID)
VALUES('BETA_ISO8859_1_NOCASE', 21, 16);
But as soon as I try to create a table with a field that uses this collation,
for example:
SET NAMES ISO8859_1;
...
CREATE DOMAIN INT_ID
AS INTEGER
NOT NULL
CHECK(VALUE > 0);
CREATE DOMAIN CH_DB_VERSION
AS VARCHAR(10)
NOT NULL
COLLATE BETA_ISO8859_1_NOCASE;
CREATE TABLE DB_Versions(
ID_Version INT_ID,
DB_Version CH_DB_VERSION);
I get an error that says:
This operation is not defined for system tables.
Unsuccessful metadata update.
What am I doing wrong?
Regards
Salvatore