Subject Re: [firebird-support] views with russian symbols in the names of fields
Author Helen Borrie
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