description: The following statement returns:
RES
-----------
0
1
But it sholud return 1 for both. I suppose the Position function does not taking in consideration the collation of blob variable.
Database: DEFAULT CHARACTER SET UTF8 COLLATION UNICODE_CI;
Connection charset: UTF8
Firebird: 3.0.2.32703
Windows 10 Pro (x64)

execute block
returns (
RES integer)
as
declare variable BL blob sub_type 1 segment size 80 collate UNICODE_CI;
declare variable TXT varchar(255) collate UNICODE_CI;
begin
bl= 'declare variable ID D_ID;declare variable TEST_FIELD D_INTEGER;';
txt = 'declare variable id d_id;';
res = position(txt, bl);
suspend;
res = position ('declare variable id d_id;','declare variable ID D_ID;declare variable TEST_FIELD D_INTEGER;');
suspend;
end

=>

The following statement returns:
RES
-----------
0
1
But it should return 1 for both. I suppose the Position function does not taking into consideration the collation of blob variable.
Database: DEFAULT CHARACTER SET UTF8 COLLATION UNICODE_CI;
Connection charset: UTF8
Firebird: 3.0.2.32703
Windows 10 Pro (x64)

execute block
returns (
RES integer)
as
declare variable BL blob sub_type 1 segment size 80 collate UNICODE_CI;
declare variable TXT varchar(255) collate UNICODE_CI;
begin
bl= 'declare variable ID D_ID;declare variable TEST_FIELD D_INTEGER;';
txt = 'declare variable id d_id;';
res = position(txt, bl);
suspend;
res = position ('declare variable id d_id;','declare variable ID D_ID;declare variable TEST_FIELD D_INTEGER;');
suspend;
end

description: The following statement returns:
RES
-----------
0
1
But it should return 1 for both. I suppose the Position function does not taking into consideration the collation of blob variable.
Database: DEFAULT CHARACTER SET UTF8 COLLATION UNICODE_CI;
Connection charset: UTF8
Firebird: 3.0.2.32703
Windows 10 Pro (x64)

execute block
returns (
RES integer)
as
declare variable BL blob sub_type 1 segment size 80 collate UNICODE_CI;
declare variable TXT varchar(255) collate UNICODE_CI;
begin
bl= 'declare variable ID D_ID;declare variable TEST_FIELD D_INTEGER;';
txt = 'declare variable id d_id;';
res = position(txt, bl);
suspend;
res = position ('declare variable id d_id;','declare variable ID D_ID;declare variable TEST_FIELD D_INTEGER;');
suspend;
end

=>

The following statement returns:
RES
-----------
0
1
But it should return 1 for both. I suppose the Position function does not taking into consideration the collation of blob variable.
Database: DEFAULT CHARACTER SET UTF8 COLLATION UNICODE_CI;
Connection charset: UTF8
Firebird: 3.0.2.32703 (x64)
Windows 10 Pro (x64)

execute block
returns (
RES integer)
as
declare variable BL blob sub_type 1 segment size 80 collate UNICODE_CI;
declare variable TXT varchar(255) collate UNICODE_CI;
begin
bl= 'declare variable ID D_ID;declare variable TEST_FIELD D_INTEGER;';
txt = 'declare variable id d_id;';
res = position(txt, bl);
suspend;
res = position ('declare variable id d_id;','declare variable ID D_ID;declare variable TEST_FIELD D_INTEGER;');
suspend;
end

assignee: Adriano dos Santos Fernandes [ asfernandes ]

description: The following statement returns:
RES
-----------
0
1
But it should return 1 for both. I suppose the Position function does not taking into consideration the collation of blob variable.
Database: DEFAULT CHARACTER SET UTF8 COLLATION UNICODE_CI;
Connection charset: UTF8
Firebird: 3.0.2.32703 (x64)
Windows 10 Pro (x64)

execute block
returns (
RES integer)
as
declare variable BL blob sub_type 1 segment size 80 collate UNICODE_CI;
declare variable TXT varchar(255) collate UNICODE_CI;
begin
bl= 'declare variable ID D_ID;declare variable TEST_FIELD D_INTEGER;';
txt = 'declare variable id d_id;';
res = position(txt, bl);
suspend;
res = position ('declare variable id d_id;','declare variable ID D_ID;declare variable TEST_FIELD D_INTEGER;');
suspend;
end

=>

The following statement returns:
RES
-----------
0
1
But it should return 1 for both. I suppose the Position function does not taking into consideration the collation of blob variable.
Database: DEFAULT CHARACTER SET UTF8 COLLATION UNICODE_CI;
Connection charset: UTF8
Firebird: 3.0.2.32703 (x64)
Windows 10 Pro (x64)

execute block
returns (
RES integer)
as
declare variable BL blob sub_type 1 segment size 80 collate UNICODE_CI;
declare variable TXT varchar(255) collate UNICODE_CI;
begin
bl= 'abc';
txt = 'ABCD';
res = position(txt, bl);
suspend;
res = position ('abc','ABCD');
suspend;
end

assignee: Adriano dos Santos Fernandes [ asfernandes ] => Vlad Khorsun [ hvlad ]

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0.3 [ 10810 ]

Fix Version: 4.0 Beta 1 [ 10750 ]

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

status: Resolved [ 5 ] => Closed [ 6 ]