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-issue-importer opened this issue Jun 2, 2011 · 13 comments

Comments

@firebird-issue-importer
Copy link

@firebird-issue-importer firebird-issue-importer commented Jun 2, 2011

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 2, 2011

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 2, 2011

Modified by: @dyemanov

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 2, 2011

Modified by: @dyemanov

Link: This issue is related to CORE2602 [ CORE2602 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 2, 2011

Modified by: @dyemanov

Version: 3.0 Initial [ 10301 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 2, 2011

Modified by: @dyemanov

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 2, 2011

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 23, 2013

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 18, 2016

Modified by: @pavel-zotov

QA Status: No test

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 23, 2016

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 23, 2016

Modified by: @pavel-zotov

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 23, 2016

Modified by: @pavel-zotov

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 23, 2016

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 12, 2016

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
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants