| Subject | UNICODE_FSS in select statement - ERROR |
|---|---|
| Author | Sasa Mihajlovic |
| Post date | 2009-03-11T18:54:23Z |
Hi,
I have table with articles, and I have a field named NAME which is represent a name of article length is 50 and collation is UNICODE_FSS.
Database with this table was created and filled with data in Firebird 2.0 and in the name column there are a lot of names with latin caracters (èæð). After finall release of Firebird 2.1 I was backup and restore database in FB1.2 and now when I open this table (for example in ibexpert) I don't see cirilic characters until click on a filed (that is for unicode characters in ib expert) and when I call some select statement:
SELECT * FROM Article WHERE Name LIKE '%NA%'
Firebird raise error
Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation.
Cannot transliterate character between character sets.
This work fine with FB2.0
Please I need some help how to solve this problem!
Thanks in advance...
I have table with articles, and I have a field named NAME which is represent a name of article length is 50 and collation is UNICODE_FSS.
Database with this table was created and filled with data in Firebird 2.0 and in the name column there are a lot of names with latin caracters (èæð). After finall release of Firebird 2.1 I was backup and restore database in FB1.2 and now when I open this table (for example in ibexpert) I don't see cirilic characters until click on a filed (that is for unicode characters in ib expert) and when I call some select statement:
SELECT * FROM Article WHERE Name LIKE '%NA%'
Firebird raise error
Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation.
Cannot transliterate character between character sets.
This work fine with FB2.0
Please I need some help how to solve this problem!
Thanks in advance...