 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CASE OPENED]Reportcaster not properly showing Spanish Characters
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CASE OPENED]Reportcaster not properly showing Spanish Characters Read-Only TopicGo | Search | Notify | Tools |
| [CASE OPENED]Reportcaster not properly showing Spanish Characters | Login/Join |
| Master |
********************************** Edit 2/24/2017 Opened up a case with IBI for help ********************************** Has anyone figured out how to resolve issues with ReportCaster mangling spanish characters. I have my code page set to 1252 everywhere I can think of -Reporting Server -Application Server -ReportCaster (Distribution Server Code Page and Webserver Code Page) -Linux Server I do not have this issue when running the report directly from the content area nor from the reporting server. This is only an issue when emailing the report from report caster (I have not tried the library but expect the issue to be the same). This is both with HTML and XLSX output types. My redirection setting for xlsx is set to Redirect = yes , Save Report = yes Any thoughts on where else to look to resolve this issue? Is it an encoding issue? ThanksThis message has been edited. Last edited by: eric.woerle, Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2 | ||
|
| Virtuoso |
Get a trace from the email server. I had an issue a couple of years ago where the attachment was multibyte and the email server was single byte. Turns out that the attachment didn't identify the proper codepage of the attachment. You could be having the same issue in reverse. If library is fine then that could be it. "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Master |
Report Library produces the same issue. I was originally thinking it could be the email server too... Doesn't seem like it. Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2 | |||
|
| Virtuoso |
Any chance you can show the before and after, and the hex values? "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Master |
All accented characters are being represented as � . doesn't matter if its an accented o, u, or i. In this case: Identificación del Estudiante became: Identificaci�n del Estudiante And: Número Consecutivo del Cupón became: N�mero Consecutivo del Cup�n Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2 | |||
|
| Virtuoso |
Interesting. It looks to me like RC is converting to a multi-byte character set, and then it is being rendered in single byte. You might want to check if there is another RC code page setting, and open a ticket. When I take the character (F3 in 1252), then convert to utf8 and then display as ascii, I get something close to what you are seeing. However, I cannot duplicate it. "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Master |
ya, I've been thinking along the same lines as you, that its saving it as muliti-byte character and excel is reading it as a single byte character (Or vice versa). I'm just completely confused why this is only a problem with RC. I'll check with IBI to see what insight they can provide on this issue. Thanks dhagen! Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2 | |||
|
| Virtuoso |
In RC, it will have to open the file to either attach it, or copy it to library. It's more than likely that read that may be causing the problem. "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Guru |
Eric, The Report Caster product manager, who checked with the NLS QA team tested out your issue. They set up similar configurations on our sandbox with code page 2152 but were unable to reproduce the issue. They have requested that you please re-check your configuration, restart the application and distribution servers as well as the reporting server and let us know your results. Here is the image received:  Thank you for participating in the Focal Point Forum! Tamra Colangelo Focal Point Moderator Information Builders WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5 | |||
|
| Silver Member |
Depending on the default encoding of you platform you may also have to set the file encoding in the Distribution Server startup script by adding -Dfile.encoding=es_ES.iso88591 to the java command in schbrk.sh. You can do locale -a on the command line to see all encoding options. WebFOCUS All Releases | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CASE OPENED]Reportcaster not properly showing Spanish Characters
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CASE OPENED]Reportcaster not properly showing Spanish CharactersCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |