No error when fetching row with UTF8 blob that cannot be transliterated to 
connection character set.
----------------------------------------------------------------------------------------------------

                 Key: CORE-5377
                 URL: http://tracker.firebirdsql.org/browse/CORE-5377
             Project: Firebird Core
          Issue Type: Bug
          Components: Charsets/Collation, Engine
    Affects Versions: 3.0.1, 3.0.0
         Environment: Jaybird 3 (master, HEAD); Firebird WI-V3.0.0.32483 and 
WI-V3.0.1.32609
            Reporter: Mark Rotteveel


I have a table:

create table test_clob (
  id integer,
  utf8_blob blob sub_type text character set utf8
)

I insert a row with UTF-8 characters using a connection with connection 
character set UTF8 and a value of 
"\u16a0\u16a1\u16a2\u16a3\u16a4\u16a5\u16a6\u16a7\u16a8\u16a9\u16aa\u16ab\u16ac\u16ad\u16ae\u16af"
 (where \unnnn is a unicode escape).

If I query that table using connection character set WIN1252 (or another single 
byte character set), the fetch will yield an op_fetch_response with code 100 
(no more rows) and row count 0. Doing the same on Firebird 2.5.6 yields error 
"Cannot transliterate character between character sets [SQLState:22018, ISC 
error code:335544565]" which is more correct (although still very annoying, I 
would rather have that error when I fetch the blob).

Reproducing with isql (slightly reduced):

set names utf8;
connect ....;
insert into test_clob(id, utf8_blob) values (1, x'e19aa0'); -- e19aa0 is UTF-8 
encoding of code point 16a0
select * from test_clob; -- yields row
set names win1252;
connect ....;
select * from test_clob; -- yields no row, instead of expected error "Cannot 
transliterate character between character sets"

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most 
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to