NetTalk Central

Author Topic: Special Character - Degree Symbol  (Read 6009 times)

RichBowman

  • Jr. Member
  • **
  • Posts: 76
    • View Profile
    • Email
Special Character - Degree Symbol
« on: March 12, 2012, 12:45:55 PM »
The degree symbol can be entered by typing Alt+0176. This works fine in my Win32 apps but my NT app can not display the record with this symbol. How can I handle this? I do not need input capability, just display.

Thank you,

Rich

AZIS350

  • Jr. Member
  • **
  • Posts: 62
    • View Profile
    • Email
Re: Special Character - Degree Symbol
« Reply #1 on: March 12, 2012, 01:58:54 PM »
The HTML code for the degree symbol is °

Give that a try and see if it works for you.

RichBowman

  • Jr. Member
  • **
  • Posts: 76
    • View Profile
    • Email
Re: Special Character - Degree Symbol
« Reply #2 on: March 13, 2012, 01:54:51 AM »
I don't think I explained my question well. The degree symbol is embedded in a field in the database. My Browse will not display a record that has that symbol in a field on the Browse. In fact, once the parent record is displayed, the parent Browse will not even do a Next. Is there a setting in NT that will allow this record to display?

Thank you,

Rich

kevin plummer

  • Hero Member
  • *****
  • Posts: 1195
    • View Profile
    • Production Accounting and Software Payroll
Re: Special Character - Degree Symbol
« Reply #3 on: March 13, 2012, 04:09:08 AM »
Have you ticked allow xhtml for that column?

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Special Character - Degree Symbol
« Reply #4 on: March 13, 2012, 06:50:31 AM »
what settings have you set for "charset" and "save as" on the webserver procedure, advanced tab?

cheers
Bruce

RichBowman

  • Jr. Member
  • **
  • Posts: 76
    • View Profile
    • Email
Re: Special Character - Degree Symbol
« Reply #5 on: March 13, 2012, 10:02:49 AM »
"Allow xhtml" is checked for that column. Both Charset and Save As in the WebServer procedure are utf-8. I should mention that I actually display a local variable. It is 2 string fields concatenated like this (so I get a 2 line row):

LineDescription = OED:LineDescription & '<br />' & OED:LineDescription2

This is on a parent / child browse form. When a parent is displayed with a child record that has the degree symbol, the child records do not display and clicking next or previous on the parent browse does not display a new set of records.

Thank you,

Rich

linas@debetas.lt

  • Jr. Member
  • **
  • Posts: 52
    • View Profile
    • Email
Re: Special Character - Degree Symbol
« Reply #6 on: March 13, 2012, 07:14:32 PM »
xhtml is very strict. what i see is that the you result as xhtml is wrong and it is not displayed because of that.

kevin plummer

  • Hero Member
  • *****
  • Posts: 1195
    • View Profile
    • Production Accounting and Software Payroll
Re: Special Character - Degree Symbol
« Reply #7 on: March 13, 2012, 08:43:31 PM »
Once you build your LineDescription try to scan for ascii value <176> and do a replace with &deg;

If you use Firebug you can see the XML errors

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Special Character - Degree Symbol
« Reply #8 on: March 14, 2012, 12:20:44 AM »
>> Both Charset and Save As in the WebServer procedure are utf-8.

you've told the server you have your data stored as utf-8, but in practice you haven't stored the data as utf-8. This is, I think, perhaps the root of your problem.
If you change to "save as Ascii" you will probably have better success.

cheers
Bruce

RichBowman

  • Jr. Member
  • **
  • Posts: 76
    • View Profile
    • Email
Re: Special Character - Degree Symbol
« Reply #9 on: March 14, 2012, 02:46:44 AM »
Changing the "Save as" character set to ASCII worked.

Thank you,

Rich