Subject | Problem changing CHARACTER SET UNICODE_FSS > ASCII. |
---|---|
Author | Constantijn Wolfs |
Post date | 2004-09-14T20:04:25Z |
Hi,
I need to change the CHARACTER SET of columns in a table from
UNICODE_FSS to ASCII.
Column 1 is of type VARCHAR(14)
Column 2 is of type CHAR(1)
Using IBExpert, when I change the CHARACTER SET of column 1 everything
seems fine.
But when I change column 2 I get an error: arithmetic exception, numeric
overflow, or string
truncation, when making a backup of the database.
Am I performing illegal operations here?
TIA
Constantijn
I need to change the CHARACTER SET of columns in a table from
UNICODE_FSS to ASCII.
Column 1 is of type VARCHAR(14)
Column 2 is of type CHAR(1)
Using IBExpert, when I change the CHARACTER SET of column 1 everything
seems fine.
But when I change column 2 I get an error: arithmetic exception, numeric
overflow, or string
truncation, when making a backup of the database.
Am I performing illegal operations here?
TIA
Constantijn