Questions? Feedback?powered byOlark live chat software

Standard Support

Bug 1739

Wrong Chinese character display on screen 17 October, 2018

Mukul Jain
12 October, 2018
Product: PowerServer Web/Mobile Category: Other
Version: 2017 Publishing: Public
Status: Reproducing Priority: P2
Classification: Issue Resolution:
Mukul Jain 17 October, 2018
Hello Zhao Kai,

We have followed the steps and Its not working, Marco has sent screen shot of same.

Thanks,
Mukul
Zhao Kai 17 October, 2018
Hi Mukul,

I had setup ASE 15.7 database with charset ‘roman8’, and the Chinese character displays well with the settings below in AEM.
1 Go to AEM > Server > Resources > Data Source to set extend options to CHARSET= 'iso_1'.
2 Go to AEM > Application > Data Transfer > Charset to set database charset to iso_8859-1 and client-side charset to Chinese.

Please try the above settings on your end and see if it works. If there is still the issue, please provide the dbparm of SQLCA which you used in PB to us for more study, thanks.

Regards,
ZhaoKai
Mukul Jain 16 October, 2018
RE   Bug 1739  Wrong Chinese character display on screen.msg (118KB)

Attaching error screen shot after changing to roman8
Mukul Jain 16 October, 2018
locales.dat (22KB)

Hello Zhao Kai,

We tried as suggested by you but issue remains same.
roman8 is not working.

Attaching locales.dat
Zhao Kai 16 October, 2018
Hi Mukul,

Please follow steps to give a try.

1 Refer to article below to add charset 'roman8' in PowerServer.
https://www.appeon.com/support/documents/appeon_online_help/2017/server_configuration_guide_for_net/Data_Transfer.html#Charset_options

2 Go to AEM > Application > Data Transfer > Charset to change the Database Charset to 'roman8'.


If there is still the issue, please provide information below to us for more study, thanks. And I am trying to create a database with charset 'roman8' to reproduce the issue.

1 Please provide the file below on PowerServer machine to us for more study, thanks.
C:\sybase\locales\locales.dat

2 Provide the result of SQL below:
select * from master.. syscharsets order by id


Regards,
ZhaoKai
Mukul Jain 16 October, 2018
Character set for all DDE ASE servers  are   Character Set = 4, roman8                                          

I will share Locale also soon
Zhao Kai 15 October, 2018
Hi Mukul,

What’s the detail ASE version you are using? What’s the charset setting on your ASE database server? Does PB application work well on the PowerServer machine? Please provide the file below on PowerServer machine to us for more study, thanks.
C:\sybase\locales\locales.dat

And please refer to below article to provide the Appeon server log and Appeon error log to us too, thanks.
http://support.appeon.com/index.php?/Knowledgebase/Article/View/50/0/what-you-can-provide-to-us-for-further-debugging-when-you-run-into-the-appeon-server-related-issues

Regards,
ZhaoKai
Mukul Jain 15 October, 2018
Send screen shot over the email to tom.jiang@appeon.com
Tom Jiang 15 October, 2018
Hi Mukul,

I will try to reproduce the issue. Please let us know your ASE charset setting. 

Regards,

Tom Jiang
Govinda Lopez 12 October, 2018
Hi Mukul,

I will transfer your ticket to our engineering team for further analysis. We will keep you posted on the results here.


Regards,
Mukul Jain 12 October, 2018
Hi,

Mistakenly put the product as Powerbuilder should be PowerServer Web but can't edit the details.
Mukul Jain 12 October, 2018
Chinese_char_issue.docx (341KB)

Hi,

I re-attached the file which includes the charset setting in AEM for your reference.

Regards,
Elena
Mukul Jain 12 October, 2018
Chinese_char_issue.docx (93KB)

*Phenomenon:
For CN,  our client-server version display the chinese character correctly but not in web version

*Reproduce Steps:


Remark:
Please see attached document as a proof.
OS:
Windows 7 
Platform:
64-bit 
Database Type:
SAP ASE 
Database Version:
Sybase 15.7