Skip to content

Incorrect error "Invalid token. Malformed string." with union + blob + non utf8 varchar #7176

@EPluribusUnum

Description

@EPluribusUnum

Hello!

CREATE TABLE test (TXT VARCHAR(10) CHARACTER SET WIN1250 COLLATE PXW_HUNDC)
INSERT INTO test(txt) VALUES ('öüóőúéáűí')

Run this select on a client with UTF8 charset

SELECT CAST(NULL AS BLOB SUB_TYPE 1) x
FROM rdb$database
UNION ALL
SELECT txt
FROM test

Invalid token.
Malformed string.
SQLCODE: -104
SQLSTATE: 22000
GDSCODE: 335544849

Server : FB 3.0.9
Client : Jaybird with charSet=UTF-8 in connstring, or IBExpert with UTF8

This works on FB25 as expected.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions