Subject | Change character set in domain definition |
---|---|
Author | Paul Sjoerdsma |
Post date | 2001-09-03T05:56:51Z |
Hello ,
using Firebird-1.0.0.338-Beta-2
I need to change the character set of certain domains. Below I have
included an example of the current DDL and what it should be.
However in the documentation there is no mention howto do this.
Is this possible?
----currently defined as-----
CREATE DATABASE 'Probos:C:\WorkArea\SURAPON.GDB'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 4096
DEFAULT CHARACTER SET ISO8859_1;
CREATE DOMAIN DMNULL_BIGSTRING AS
VARCHAR(80) CHARACTER SET NONE;
---Should be----
CREATE DOMAIN DMNULL_BIGSTRING AS
VARCHAR(80);
TIA
Paul Sjoerdsma
--
Best regards,
Paul
mailto:paulg@...
DOS Computers manufactured by companies such as IBM, Compaq, Tandy,
and millions of others are by far the most popular, with about 70
million machines in use worldwide. Macintosh fans, on the other hand,
may note that cockroaches are far more numerous than humans, and that
numbers alone do not denote a higher life form.
-- New York Times, November 26, 1991
using Firebird-1.0.0.338-Beta-2
I need to change the character set of certain domains. Below I have
included an example of the current DDL and what it should be.
However in the documentation there is no mention howto do this.
Is this possible?
----currently defined as-----
CREATE DATABASE 'Probos:C:\WorkArea\SURAPON.GDB'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 4096
DEFAULT CHARACTER SET ISO8859_1;
CREATE DOMAIN DMNULL_BIGSTRING AS
VARCHAR(80) CHARACTER SET NONE;
---Should be----
CREATE DOMAIN DMNULL_BIGSTRING AS
VARCHAR(80);
TIA
Paul Sjoerdsma
--
Best regards,
Paul
mailto:paulg@...
DOS Computers manufactured by companies such as IBM, Compaq, Tandy,
and millions of others are by far the most popular, with about 70
million machines in use worldwide. Macintosh fans, on the other hand,
may note that cockroaches are far more numerous than humans, and that
numbers alone do not denote a higher life form.
-- New York Times, November 26, 1991