Webserver Report - Problems with special caracters (Spanish) Encoding

[urayoan]

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

[Bruce]

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

[urayoan]

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]

[urayoan]

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

[Bruce]

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

[urayoan]

Hi Bruce:

That is correct, it works!

Any way to convert the existing data?

Any recommendation will be appreciated

Thank you again!

[Bruce]

>> 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

[urayoan]

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