--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> 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

I use tool named IBExpert. It's really "cyrilic friendly" and I build
database with it.
As I now, such views can be created only with sql dialect 3.
If UNICODE_FSS charset is used (both on server and client) I can even
select data and insert data though view-trigger-procedure method in
the view for some time, but after all it breaks up with same error.
Usage of cp1251 gives worse result.

Is it a bug or I am just not experienced enough

zergio