Subject | Re: [firebird-support] views with russian symbols in the names of fields |
---|---|
Author | Helen Borrie |
Post date | 2003-10-24T11:53:56Z |
At 11:02 AM 24/10/2003 +0000, you wrote:
heLen
>Hello All!You must set the client to the same character set as the database.
>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.
heLen