Subject | Re: views with russian symbols in the names of fields |
---|---|
Author | peter_jacobi.rm |
Post date | 2003-10-24T13:28:45Z |
I can confirm the defect report from zergicomb.
I used this ISQL session (FB1.5rc4 W2K) to reproduce:
Note1: I hope the russian words I c'n'p'ed from some
website are not offensive
Note2: All russian characters transformed into numerical
entities by yahoogroups web interfave
F:\fb15rc4\firebird15\cstest>chcp 1251
Active code page: 1251
F:\fb15rc4\firebird15\cstest>..\bin\isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> set names win1251;
SQL> create database 'f:\cyr.fdb' user 'sysdba' password 'masterkey';
SQL> create table t2 (c1 char(10) character set win1251, c2 char(10)
character set win1251);
SQL> insert into t2 values ('Виды', 'приборов');
SQL> insert into t2 values ('abc', 'def');
SQL> select * from t2;
C1 C2
========== ==========
Виды приборов
abc def
SQL> create view v2 ("Виды", "приборов") as select c1, c2 from t2;
Statement failed, SQLCODE = -607
unsuccessful metadata update
-STORE RDB$RELATION_FIELDS failed
-arithmetic exception, numeric overflow, or string truncation
-Cannot transliterate character between character sets
SQL> exit;
Regards,
Peter Jacobi
I used this ISQL session (FB1.5rc4 W2K) to reproduce:
Note1: I hope the russian words I c'n'p'ed from some
website are not offensive
Note2: All russian characters transformed into numerical
entities by yahoogroups web interfave
F:\fb15rc4\firebird15\cstest>chcp 1251
Active code page: 1251
F:\fb15rc4\firebird15\cstest>..\bin\isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> set names win1251;
SQL> create database 'f:\cyr.fdb' user 'sysdba' password 'masterkey';
SQL> create table t2 (c1 char(10) character set win1251, c2 char(10)
character set win1251);
SQL> insert into t2 values ('Виды', 'приборов');
SQL> insert into t2 values ('abc', 'def');
SQL> select * from t2;
C1 C2
========== ==========
Виды приборов
abc def
SQL> create view v2 ("Виды", "приборов") as select c1, c2 from t2;
Statement failed, SQLCODE = -607
unsuccessful metadata update
-STORE RDB$RELATION_FIELDS failed
-arithmetic exception, numeric overflow, or string truncation
-Cannot transliterate character between character sets
SQL> exit;
Regards,
Peter Jacobi