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

MON$DATABASE_NAME and MON$ATTACHMENT_NAME fields contain question marks instead of non-ASCII characters regardless of the connection charset [CORE3508] #3866

Closed
firebird-automations opened this issue Jun 2, 2011 · 13 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @dyemanov

Is related to CORE2602

Attachments:
c3508-non-readable-non-ascii-characters-in-mon-tables.zip
c3508-utf-LINUX-screen.PNG

If the database name or alias contain non-ASCII characters, they get replaced with question marks in the monitoring tables. Accordingly to CORE2602, it could be expected for the NONE connection charset, but in fact it happens for any charset, including Unicode ones.

Commits: be635fd 17be2f2

@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

Modified by: @dyemanov

Link: This issue is related to CORE2602 [ CORE2602 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Version: 3.0 Initial [ 10301 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.1 [ 10333 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Commented by: @pavel-zotov

Create following script:

shell del C:\MIX\firebird\QA\fbt-repo\tmp\Ministère_des_Affaires_étrangères 2>nul;
shell del C:\MIX\firebird\QA\fbt-repo\tmp\Министерство_иностранных_дел 2>nul;
set names utf8;
create database '/3333:C:\MIX\firebird\QA\fbt-repo\tmp\Ministère_des_Affaires_étrangères'; // Name of Ministry of Foreign Affairs in France
set list on;
select 'literal string' as source, 'Ministère_des_Affaires_étrangères' as non_ascii_name from rdb$database
union all
select 'mon$database_name', mon$database_name from mon$database
union all
select 'mon$attachment_name', mon$attachment_name from mon$attachments where mon$attachment_id = current_connection
;
commit;
drop database;

create database '/3333:C:\MIX\firebird\QA\fbt-repo\tmp\Министерство_иностранных_дел'; // Name of Ministry of Foreign Affairs in Russia

select 'literal string' as source, 'Министерство_иностранных_дел' as non_ascii_name from rdb$database
union all
select 'mon$database_name', mon$database_name from mon$database
union all
select 'mon$attachment_name', mon$attachment_name from mon$attachments where mon$attachment_id = current_connection
;
commit;
drop database;

Then run cmd.exe and do there:

chcp 65001
C:\>cd C:\MIX\firebird\QA\fbt-repo\tmp\
C:\MIX\firebird\QA\fbt-repo\tmp>isql -q -i c3508-utf.sql 1>c3508-utf.log 2>&1

Then open c3508-utf.log in editor that supports unicode (I use Notepad++).
You will see readable all names _except_ those that are selected from mon$ tables.

Source .sql, .log and screenshot are in attached .zip file.

PS. WI-V3.0.0.32281

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

Attachment: c3508-non-readable-non-ascii-characters-in-mon-tables.zip [ 12880 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

Attachment: c3508-utf-LINUX-screen.PNG [ 12881 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pavel-zotov

... and no any problem on Linux, database with non-ascii characters in its name is displayed properly - see attached .png.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Deferred

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