Introducer (_charset) problems with monitoring and persistent modules [CORE2607]

[firebird-automations]

Submitted by: @asfernandes

Is related to QA413

Usage of introducer (_charset ) is problematic due to usage of different character sets in a single command. The problems are different from version to version, and may be transliteration error, malformed string or just unexpected things.

It happens in two different usage scenarios.
1) When a query use it, and another selects from MON$STATEMENTS.
2) When it's used in a persistent module (SP, trigger).

The solution for the problem is to transform the introducer strings to a form capable to be represented in ASCII characters.

So, for example, this command:
select _dos850 '123áé456' from rdb$database
May be transformed to:
select _dos850 X'313233A082343536' from rdb$database

Commits: f590889

[firebird-automations]

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 2.5 RC1 [ 10362 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA413 [ QA413 ]

[firebird-automations]

Modified by: @pcisar

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

[firebird-automations]

Commented by: @pcisar

Test added.

[firebird-automations]

Modified by: @pavel-zotov

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

QA Status: Done successfully