Menu
▾
▴
#27 Unicode names substituted to html &##; characters in email
Some SPMS users are complaining that the unicode in their names in SPMS is being translated to HTML &##; characters when receiving emails from SPMS. For example, email to Håkan Danared from SPMS produces the opening greeting substitution
Dear Håkan Danared,
instead of the proper unicode name
Dear Håkan Danared,
as it is stored in SPMS.
Related
Note that the HTML code of complaint above is seen by him as "H &# 229 ; kan" (without the spaces) but of course on this web form the HTML version of the symbol is printed normally in most web browsers.
Todd,
From what I can tell, this is a database issue. Take a look at https://oraweb2.cern.ch/pls/jacow/test.
Line 1 is data stored in a table. I entered the data with the following: insert into temp values ('Håkan'). What you see is the result of the print out to the web.
The å character is stored in the database as chr(191), which I think is wrong.
Line 2 is a straight print of his name in the HTML code htp.header(3, 'Håkan'). As you can see this displays properly indicating it is not an issue with the web server or browser.
Line 3 is a straight print using htp.header(3, 'H¿kan'). I used #191 because that is what was stored in the database for the å character, which appears to be wrong.
Line 4 is a straight print using htp.header(3, 'Håkan'), which is the number you gave me. This appears correctly as well.
I think the database either doesn’t accept Unicode, is not setup properly or the interaction between the SPMS pages and the database is not correct for Unicode. If it is a database issue and given the CERN database hosts other applications, I’m not sure if we can make a request to have it changed.
Matt Arena
Applications Developer & Systems Analyst
Information Systems
Fermi National Accelerator Laboratory
630 840 4793 office
www.fnal.govhttp://www.fnal.gov/
From: Todd Satogata [mailto:satogata@users.sf.net]
Sent: Monday, May 09, 2016 12:30 AM
To: Matthew Arena arenam@fnal.gov
Subject: [jacow-spms:bugs] #27 Unicode names substituted to html &##; characters in email
Note that the HTML code of complaint above is seen by him as "H &# 229 ; kan" (without the spaces) but of course on this web form the HTML version of the symbol is printed normally in most web browsers.
[bugs:#27]https://sourceforge.net/p/jacow-spms/bugs/27/ Unicode names substituted to html &##; characters in email
Status: open
Group: v1.0_(example)
Created: Mon May 09, 2016 05:27 AM UTC by Todd Satogata
Last Updated: Mon May 09, 2016 05:27 AM UTC
Owner: nobody
Some SPMS users are complaining that the unicode in their names in SPMS is being translated to HTML &##; characters when receiving emails from SPMS. For example, email to Håkan Danared from SPMS produces the opening greeting substitution
Dear Håkan Danared,
instead of the proper unicode name
Dear Håkan Danared,
as it is stored in SPMS.
Sent from sourceforge.net because arenam@fnal.govarenam@fnal.gov is subscribed to https://sourceforge.net/p/jacow-spms/bugs/
To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/jacow-spms/admin/bugs/options. Or, if this is a mailing list, you can unsubscribe from the mailing list.
Related
Bugs: #27