Questions? Feedback?powered byOlark live chat software

Standard Support

Bug 1739

Wrong Chinese character display on screen 22 October, 2018

Mukul Jain
12 October, 2018
Product: PowerServer Web/Mobile Category: Other
Version: 2017 Publishing: Public
Status: Reproducing Priority: P2
Classification: Issue Resolution:
supportteam 22 October, 2018
Hi Mukul,

Please send us all charsets that your PowerServer machine supports for further analysis. 

Thanks,
Zhaokai
Mukul Jain 21 October, 2018
Charset not support.docx (63KB)

(In reply to Zhao Kai from comment #20)
Hi Mukul,
 
Please set the Client-side charset to 'windows-1252' but not Database
Charset in AEM, the database charset should be 'ios_8859-1'.

And please test if 'ios_8859-1' and 'chinese' are supported by using the
simple tool.

Regards,
ZhaoKai
Hi Zhaokai, We tried above steps. However its not work because 'ios_8859-1' not supported. Please see the attached documents.
Zhao Kai 21 October, 2018
Hi Mukul,
 
Please set the Client-side charset to 'windows-1252' but not Database Charset in AEM, the database charset should be 'ios_8859-1'.

And please test if 'ios_8859-1' and 'chinese' are supported by using the simple tool.

Regards,
ZhaoKai
Mukul Jain 19 October, 2018
Wrong Chinese character display on screen.docx (168KB)

(In reply to Zhao Kai from comment #18)
testencoding

Hi Mukul,

This problem might be caused by that the charset configured is not supported
by Appeon PowerServer machine. 
The charset in AEM > Application > Data Transfer > Charset, no matter it is
the database charset or it is the client-side charset should be the charset
that is supported by machine with the Appeon PowerServer installed. 

You try to download and run the attached small tool( or use attached same
file) and see if the configured charset is supported (please note .Net
framework 2.0 is required to run this small tool).
http://demo.appeon.com/ear/testencoding.zip
Please follow the below steps to run the provided tool:
1.	On the client machine, run the provided tool, and then click “Get Default
Encoding”. Check the charset encoding you get and then set the same encoding
in AEM Client-side charset.
2.	On the Appeon PowerServer machine, run the provided tool, and then click
"Get Available charset" to get the charset list the current machine
supports. You will find in the charset list, the charset in the Name column
are those that is selectable in AEM. 
You may enter a charset name and click “Test” to see if the charset is
supported by the current machine. 

Regards,
ZhaoKai
Hi, We tested the application as per steps provided but some Chinese is not coming correctly. Please see the attached screen shot for your references.
Zhao Kai 19 October, 2018
testencoding

Hi Mukul,

This problem might be caused by that the charset configured is not supported by Appeon PowerServer machine. 
The charset in AEM > Application > Data Transfer > Charset, no matter it is the database charset or it is the client-side charset should be the charset that is supported by machine with the Appeon PowerServer installed. 

You try to download and run the attached small tool( or use attached same file) and see if the configured charset is supported (please note .Net framework 2.0 is required to run this small tool).
http://demo.appeon.com/ear/testencoding.zip
Please follow the below steps to run the provided tool:
1.	On the client machine, run the provided tool, and then click “Get Default Encoding”. Check the charset encoding you get and then set the same encoding in AEM Client-side charset.
2.	On the Appeon PowerServer machine, run the provided tool, and then click "Get Available charset" to get the charset list the current machine supports. You will find in the charset list, the charset in the Name column are those that is selectable in AEM. 
You may enter a charset name and click “Test” to see if the charset is supported by the current machine. 

Regards,
ZhaoKai
Mukul Jain 19 October, 2018
Sys_Properties.docx (162KB)

Hi,

Please find the information as requested.

Thanks,
Mukul
Zhao Kai 18 October, 2018
system

Hi Mukul,

Please provide the screenshot of system property on PowerServer machine like attached to us for more study, thanks.

Regards,
ZhaoKai
Mukul Jain 18 October, 2018
Tried below as well, issue remains

----------
This is the settings of Oct. 12:
1.	Since it is selected, the details of the data source Extended Options cannot be seen clearly.
2.	The database charset is iso-8859-1 (hyphen) but not the suggested iso_8859-1 (underline).

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

That is the settings of Oct. 12:
1.	Since it is selected, the details of the data source Extended Options cannot be seen clearly.
2.	The database charset is iso-8859-1 (hyphen) but not the suggested iso_8859-1 (underline).

Please try the suggested settings below and then restart IIS with the ‘iisreset’ command:
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.

IF there’s still the issue,please provide the dbparm of SQLCA which you used in PB to us for more study, 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 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