Subject | Cannot transliterate character... |
---|---|
Author | lackonagy |
Post date | 2004-04-26T08:10:50Z |
I create a database using a script like:
"SET SQL DIALECT 3;
SET NAMES ISO8859_1;
CREATE DATABASE 'C:\MyDB'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 8192
DEFAULT CHARACTER SET ISO8859_1;
....
and so on
..."
There is a stored procedure which suspends a string (varchar(25))
with the german character "ß" (Alt + 0223).
When executed, the procedure fails with an error message:
"Arithmetic overflow or division by zero has occured.
arithmetic exception, numeric overflow, or string truncation.
Cannot transliterate character between character sets."
However, after recompiling the procedure it works fine.
Can anyone help me with this one?
Thanks in advance,
Laszlo Nagy.
"SET SQL DIALECT 3;
SET NAMES ISO8859_1;
CREATE DATABASE 'C:\MyDB'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 8192
DEFAULT CHARACTER SET ISO8859_1;
....
and so on
..."
There is a stored procedure which suspends a string (varchar(25))
with the german character "ß" (Alt + 0223).
When executed, the procedure fails with an error message:
"Arithmetic overflow or division by zero has occured.
arithmetic exception, numeric overflow, or string truncation.
Cannot transliterate character between character sets."
However, after recompiling the procedure it works fine.
Can anyone help me with this one?
Thanks in advance,
Laszlo Nagy.