New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Cannot use select with collate on blob field created with domain [CORE6249] #6493
Comments
Modified by: Rudi Feijó (rudi.feijo_multidadosti.com.br)description: CREATE DOMAIN DOMAINBLOB AS BLOB SUB_TYPE 0 SEGMENT SIZE 80; select * from test where blobfield collate win_ptbr containing '123'; throws : => CREATE DOMAIN DOMAINBLOB AS BLOB SUB_TYPE 0 SEGMENT SIZE 80 CHARACTER SET WIN1252; select * from test where blobfield collate win_ptbr containing '123'; throws : |
Modified by: Rudi Feijó (rudi.feijo_multidadosti.com.br)description: CREATE DOMAIN DOMAINBLOB AS BLOB SUB_TYPE 0 SEGMENT SIZE 80 CHARACTER SET WIN1252; select * from test where blobfield collate win_ptbr containing '123'; throws : => CREATE DOMAIN DOMAINBLOB AS BLOB SUB_TYPE 0 SEGMENT SIZE 80; select * from test where blobfield collate win_ptbr containing '123'; throws : |
Commented by: @dyemanov 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; |
Commented by: Rudi Feijó (rudi.feijo_multidadosti.com.br) It works in 3.0.3, I understand the current fix of CORE5846 / 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. |
Issue still persists with 3.0.10. |
The issue is opened, so it has not changed. And accordingly to the comments, I think it should be closed as wontfix. |
Submitted by: Rudi Feijó (rudi.feijo_multidadosti.com.br)
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.
The text was updated successfully, but these errors were encountered: