Issue Details (XML | Word | Printable)

Key: CORE-6249
Type: Bug Bug
Status: Open Open
Priority: Minor Minor
Assignee: Unassigned
Reporter: Rudi Feijó
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Cannot use select with collate on blob field created with domain

Created: 17/Feb/20 01:56 PM   Updated: 17/Feb/20 02:13 PM
Component/s: None
Affects Version/s: 3.0.4, 3.0.5
Fix Version/s: None

QA Status: No test


 Description  « Hide
CREATE DOMAIN DOMAINBLOB AS BLOB SUB_TYPE 0 SEGMENT SIZE 80;
CREATE TABLE TEST ( BLOBFIELD DOMAINBLOB );

select * from test where blobfield collate win_ptbr containing '123';

throws :
Dynamic SQL Error.
SQL error code = -204.
Data type unknown.
Invalid use of CHARACTER SET or COLLATE.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 17/Feb/20 02:03 PM
Sub type 0 is a binary blob, you cannot use collates with binary data,

Try something like this:

CREATE DOMAIN DOMAINBLOB AS BLOB SUB_TYPE TEXT CHARACTER SET WIN1252;

Rudi Feijó added a comment - 17/Feb/20 02:13 PM
It works in 3.0.3, I understand the current fix of CORE-5846 / 6240 is ideal and correct, but since I cannot change blob types or alter their domain/character set, I'm left with the only option of recreating my old blob fields which have no character set.
Would an improvement to be able to change blob's character set be feasible to be considered?