Subject Re: views with russian symbols in the names of fields
Author zergicomb
--- 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?