Skip to content
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

The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables [CORE2531] #2941

Closed
firebird-automations opened this issue Jun 26, 2009 · 9 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @dyemanov

Is related to QA238

Votes: 1

If any non-Unicode connection has some statements prepared and appropriate SQL text contains non-ASCII characters and the MON$ tables are queried in an Unicode connection, this error is thrown by any v2.1 version.

In v2.1.3 RC1, the situation is even worse: error may happen even if the MON$ tables are queried using the same attachment charset, provided that it's not Unicode. The patch to fix the regression and revert to the pre-v2.1.3 behavior is a trivial one-liner, but a complete fix is somewhat more difficult.

Commits: 1f59fa0

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => In Progress [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Douglas Tosi (douglasht)

I've been hit by this on a number of occasions. What I do (and recommend my users to do) is use the same charset on the monitoring attachment and on other client attachments.
Unfortunately this is not always possible or desirable.

The complete fix would be most welcome.
Voted +1.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: In Progress [ 3 ] => Open [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

The whole patch is to be backported into HEAD.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.1.3 [ 10302 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA238 [ QA238 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment