At 12:29 PM 24/10/2003 +0000, you wrote:

>--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
>wrote:
> > At 11:02 AM 24/10/2003 +0000, you wrote:
> > >Hello All!
> > >I'm using FirebirdSS-1.0.3.972.
> > >I've made a view with the statement:
> > >
> > >create view new_view ( "идетификатор", "имя" )
> > >as
> > >select id, name from person
> > >
> > >where everything between "" are russian characters. After I tried to
> > >manipulate or select the data I got the error:
> > >arithmetic exception, numeric overflow, or string truncation
> > >Cannot transliterate character between character sets
> > >
> > >I created databases with both WIN1251 and UNICODE_FSS charsets and
> > >connected to database pointing what charset to use, however I always
> > >got similar result sooner or later.
> > >Same error occurs almost every time I manipulate such "russian" views
> > >
> > >Do you know what shell I do to fix the problem.
> >
> > You must set the client to the same character set as the database.
> >
> > heLen
>
>I did so. If I create database with UNICODE_FSS then I choose
>UNICODE_FSS on a client.
>
>Did you mean that, Helen?

Oh sorry, I answered that too fast!! And I can't answer it at all -
although I am VERY interested to know the answer.

I can't even create that view at all, or any view that doesn't user the
normal "allowed" characters (Ascii 128 or less).

unsuccessful metadata update
STORE RDB$RELATION_FIELDS failed
arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets

But it's just struck me to wonder how you *do* define data from a Cyrillic
keyboard. You do it every day, and you say that you were able to define
your view. I'm very curious...

heLen