| Product: | PowerServer Web/Mobile | Category: | Other |
| Version: | 2017 | Publishing: | Public |
| Status: | Reproducing | Priority: | P2 |
| Classification: | Issue | Resolution: |
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, ZhaoKaiHi Zhaokai, We tried above steps. However its not work because 'ios_8859-1' not supported. Please see the attached documents.
Created attachment 1924 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.
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 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
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, ZhaoKaiHi, We tested the application as per steps provided but some Chinese is not coming correctly. Please see the attached screen shot for your references.
Created attachment 1923 Wrong Chinese character display on screen.docx (168KB) (In reply to Zhao Kai from comment #18) > Created attachment 1922 > 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.
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
Created attachment 1922 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
Sys_Properties.docx (162KB) Hi, Please find the information as requested. Thanks, Mukul
Created attachment 1921 Sys_Properties.docx (162KB) Hi, Please find the information as requested. Thanks, Mukul
system Hi Mukul, Please provide the screenshot of system property on PowerServer machine like attached to us for more study, thanks. Regards, ZhaoKai
Created attachment 1920 system Hi Mukul, Please provide the screenshot of system property on PowerServer machine like attached to us for more study, thanks. Regards, ZhaoKai
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). -----------
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). -----------
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
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
Hello Zhao Kai, We have followed the steps and Its not working, Marco has sent screen shot of same. Thanks, Mukul
Hello Zhao Kai, We have followed the steps and Its not working, Marco has sent screen shot of same. Thanks, Mukul
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
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
RE Bug 1739 Wrong Chinese character display on screen.msg (118KB) Attaching error screen shot after changing to roman8
Created attachment 1900 RE Bug 1739 Wrong Chinese character display on screen.msg (118KB) Attaching error screen shot after changing to roman8
locales.dat (22KB) Hello Zhao Kai, We tried as suggested by you but issue remains same. roman8 is not working. Attaching locales.dat
Created attachment 1899 locales.dat (22KB) Hello Zhao Kai, We tried as suggested by you but issue remains same. roman8 is not working. Attaching locales.dat
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
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
Character set for all DDE ASE servers are Character Set = 4, roman8 I will share Locale also soon
Character set for all DDE ASE servers are Character Set = 4, roman8 I will share Locale also soon
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
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
Send screen shot over the email to tom.jiang@appeon.com
Send screen shot over the email to tom.jiang@appeon.com
Hi Mukul, I will try to reproduce the issue. Please let us know your ASE charset setting. Regards, Tom Jiang
Hi Mukul, I will try to reproduce the issue. Please let us know your ASE charset setting. Regards, Tom Jiang
Hi Mukul, I will transfer your ticket to our engineering team for further analysis. We will keep you posted on the results here. Regards,
Hi Mukul, I will transfer your ticket to our engineering team for further analysis. We will keep you posted on the results here. Regards,
Hi, Mistakenly put the product as Powerbuilder should be PowerServer Web but can't edit the details.
Hi, Mistakenly put the product as Powerbuilder should be PowerServer Web but can't edit the details.
Chinese_char_issue.docx (341KB) Hi, I re-attached the file which includes the charset setting in AEM for your reference. Regards, Elena
Created attachment 1881 Chinese_char_issue.docx (341KB) Hi, I re-attached the file which includes the charset setting in AEM for your reference. Regards, Elena
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.
Created attachment 1880 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.
