Subject Re: [firebird-support] UNICODE_FSS in select statement - ERROR
Author Vlad Khorsun
> I have table with articles, and I have a field named NAME which is represen=
> t 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 a=
> nd in the name column there are a lot of names with latin caracters (=9A=E8=
> =E6=9A=F0=9E). After finall release of Firebird 2.1 I was backup and restor=
> e 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 unicod=
> e characters in ib expert) and when I call some select statement:
> SELECT * FROM Article WHERE Name LIKE '%NA%'
> Firebird raise error=20
> 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!

Looks like you stored non-unicode text in unicode column. If this is so
you need to convert text into correct encoding. You could take a look at
metadata upgrade SP's to take a hint how to do it.

Regards,
Vlad