NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: urayoan on December 05, 2014, 08:15:26 AM

Title: Webserver Report - Problems with special caracters (Spanish) Encoding
Post by: urayoan on December 05, 2014, 08:15:26 AM

Hi:
  I am using C9.1.11396 release and NetTalk 8.32 with the latest of the needed templates.

I am having issues with special characters in the reports. I set the encoding in the web server to UTF-8 (Spanish does not work anymore) and i see the characters like this González-Bianchi Edgardo.

Any recommendations would be great. Thanks in advance

Title: Re: Webserver Report - Problems with special caracters (Spanish) Encoding
Post by: Bruce on December 07, 2014, 09:41:16 PM

Hi Ura,

In the WebServer procedure, Advanced tab, what are
Charset
and
Store Data As
set to?

My recommendation would be to set Charset as 'utf-8' and
Save as to be Spanish. If there's a problem with that let me know.

cheers
Bruce

Title: Re: Webserver Report - Problems with special caracters (Spanish) Encoding
Post by: urayoan on December 08, 2014, 08:03:19 AM

Hi Bruce, it is already done with utf-8 and i am still having the problem.

Even sendmail procedures are having problems too

[attachment deleted by admin]

Title: Re: Webserver Report - Problems with special caracters (Spanish) Encoding
Post by: urayoan on December 08, 2014, 08:05:35 AM

BTW, the screenshot shows utf-8 in both settings, and at least let me store the special characters well but the display in the report is ugly.

Another combination i did use was ISO-8859-1 but no luck

Title: Re: Webserver Report - Problems with special caracters (Spanish) Encoding
Post by: Bruce on December 08, 2014, 10:26:34 PM

Hi Ura,

If you store-as utf-8 then the text on reports (and in Clarion windows programs) will not be correct because Clarion string controls on screens and reports (and entry controls on screens) do not know how to handle utf-8.

That is why "save as Spanish" is recommended. Keeping the charset as 'utf-8' is recommended.

Note that there's no automatic conversion of your existing data when you change this setting. So when testing I recommend
a) set the settings as I recommended
b) test with new data.

cheers
Bruce

Title: Re: Webserver Report - Problems with special caracters (Spanish) Encoding
Post by: urayoan on December 09, 2014, 05:10:40 AM

Hi Bruce:

That is correct, it works!

Any way to convert the existing data?

Any recommendation will be appreciated

Thank you again!

Title: Re: Webserver Report - Problems with special caracters (Spanish) Encoding
Post by: Bruce on December 09, 2014, 07:27:18 AM

>> Any way to convert the existing data?

hmm - maybe. But make it easy for me please. Can you list all the "spanish characters"?
Part of detecting if it's utf-8 or ANSI will be in looking at the string to see if it contains "only ASCII < 128 and spanish extended characters..'

cheers
Bruce

Title: Re: Webserver Report - Problems with special caracters (Spanish) Encoding
Post by: urayoan on December 09, 2014, 12:52:37 PM

Spanish special characters are á é í ó ú ñ ü Á É Í Ó Ú Ñ Ü

I did it manually, not too much records to update, but it will be interesting to know how to make the conversion automatically

Thanks again Bruce