Subject Re: UNICODE_FSS in select statement - ERROR
Author Sasa Mihajlovic
--- In, "Vlad Khorsun" <hvlad@...> wrote:
> > 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
Hi Vlad,

It is not non-unicode caracters it is characters from win1251 set (latin) but I can't posti it here because this editor don't support them after posting message.

Here is one add: I was backup and restore my firebrid database 2.0 with firebird 2.1.1 in all cases when this don't work!