Hi

I'm trying to display some special characters in the labels of some fields in one of our apps

α, β, γ

however when I run the app they all show as ¿, any ideas?

Also on a slightly related note, we have a radiogroup that is needed to store the following values "< 7.5" and "> 150". I get an error when I try and save this :-

The value of attribute "value" associated with an element type "radioButton" must not contain the '<' character.

this is the code I'm trying to use

  <cell columnSpan="4" hAlign="Center" vAlign="Full">
    <radioButton buttonGroup="environment_exp_dose_btngrp" value="<7 µsVh" />
  </cell>

any thoughts? It kinda feels like a bug... or maybe I should be escaping the < symbol?

asked 03 Nov '15, 05:15

apacheuk's gravatar image

apacheuk
1391223
accept rate: 0%

edited 03 Nov '15, 05:16


Hi,

Special characters of XML has to be escaped in any XML content. So, in order to add "<", ">" signs, you need to escape them. e.g. for "<", you need to write "&lt;".

On the other hand, Formspider supports all unicode characters in labels. α, β, γ have to be seen as it is. I tried it locally in a button label and it worked as expected. Can you share a sample XML for this?

Regards, Serdar

link

answered 03 Nov '15, 06:55

Serdar's gravatar image

Serdar ♦♦
100k4
accept rate: 14%

edited 03 Nov '15, 07:09

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
1.5k5

this is the extract from our definition file, also noted that if I save the XML file close the tab then reopen it, its now displaying ¿ in the source as well.

      <cell hAlign="Full" vAlign="Full">
    <textLabel label="α" backgroundColor="lightGray" text-align="Center"/>
  </cell>
  <cell hAlign="Full" vAlign="Full">
    <checkBox column="RAD_TYPE_ALPHA" dataSource="V_RRA1" checkedValue="Y" uncheckedValue="N" checked="N"/>
  </cell>
  <cell hAlign="Full" vAlign="Full">
    <textLabel label="β" backgroundColor="lightGray" text-align="Center"/>
  </cell>
  <cell hAlign="Full" vAlign="Full">
    <checkBox column="RAD_TYPE_BETA" dataSource="V_RRA1" checkedValue="Y" uncheckedValue="N" checked="N"/>
  </cell>
  <cell hAlign="Full" vAlign="Full">
    <textLabel label="γ" backgroundColor="lightGray" text-align="Center"/>
  </cell>
link

answered 04 Nov '15, 06:42

apacheuk's gravatar image

apacheuk
1391223
accept rate: 0%

Hi,

Which browser do you use?

(04 Nov '15, 06:53) Serdar ♦♦

we are currently using IE9

Simon

(04 Nov '15, 07:41) apacheuk

please ensure that page encoding is UTF-8. In IE9 menu, there is an "Encoding" menu under "View" menu, you can check there if it is Uncode or not.

(04 Nov '15, 08:49) Serdar ♦♦

have tried that, it wasn't set to UTF-8, I changed it to UTF-8 and got the same results :(

(04 Nov '15, 09:06) apacheuk

Hi Simon,

Can you try the escaped value "&#946;" instead of "β"?

If this works, you can escape other special characters too, you can find the complete list below:

https://en.wikipedia.org/wiki/List_of_XML_and_HTML_character_entity_references

Regards,
Ibrahim

(05 Nov '15, 02:52) Ibrahim Sand... ♦♦

get an error when trying to save the XML

ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00217: invalid character 946 (U+03B2) Error at line 33

this is the XML

<textlabel label="β" backgroundcolor="lightGray" text-align="Center"/>

The browser is showing the correct character above when I paste the XML in :) But I've esentially set it to "&#946 ;" - without the space included

link

answered 05 Nov '15, 03:42

apacheuk's gravatar image

apacheuk
1391223
accept rate: 0%

edited 05 Nov '15, 03:46

Hi Simon,

Just after saving your panel with the special characters, please press Ctrl+Alt+Shift+B, this opens a window displaying Formspider's request/repsonse XMLs.

At the bottom you will see the last request and response XMLs which contains your saved panel XML too. The request seems someting like below:

....
---------------
Thu Nov 05 2015 10:33:27 GMT+0200 (GTB Standard Time)
in_delta_xml : <delta>...

Can you post this part please?

Regards,
Ibrahim

(05 Nov '15, 04:09) Ibrahim Sand... ♦♦

Posted below, its

Thu Nov 5 09:34:01 UTC 2015
in_delta_xml : <delta><component oid="530134" currentEditorInstance="1"><editorInstance order="1"><value multiPart="Y"><part no="1">&lt;root xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://bdcbappr13:9005/formspider_d1/formspider.xsd"&gt;
  &lt;panel borderType="LineBorder"&gt;
    &lt;tableLayout cellSpacing="5"&gt;
      &lt;row height="30"&gt;
        &lt;cell width="200" columnSpan="12" hAlign="Full" vAlign="Full"&gt;
          &lt;textLabel font-style="Bold" font-size="18" label="Operational Radiological Hazard" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
      &lt;/row&gt;
      &lt;row height="60"&gt;
        &lt;cell width="200" hAlign="Full" vAlign="Full"&gt;
          &lt;textLabel label="Principal nuclides [a]" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell width="50" hAlign="Full" vAlign="Full"&gt;
          &lt;button label="Edit"&gt;
            &lt;events&gt;
              &lt;buttonPress action="RRA_click_RRAN"/&gt;
            &lt;/events&gt;
          &lt;/button&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="10" hAlign="Full" vAlign="Full"&gt;
          &lt;textArea name="principalnuclides" editable="N" wordWrap="Y" column="ISO_STRING" dataSource="V_RRA1"&gt;
            &lt;events&gt;
              &lt;rightClick action="RRA_click_RRAN"/&gt;
            &lt;/events&gt;
          &lt;/textArea&gt;
        &lt;/cell&gt;
      &lt;/row&gt;
      &lt;row height="20"&gt;
        &lt;cell width="200" hAlign="Full" vAlign="Top"&gt;
          &lt;textLabel label="Radiation Type [a]" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="2" hAlign="Full" vAlign="Full"&gt;
          &lt;textLabel label="&amp;#946;" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell hAlign="Full" vAlign="Full"&gt;
          &lt;checkBox column="RAD_TYPE_ALPHA" dataSource="V_RRA1" checkedValue="Y" uncheckedValue="N" checked="N"/&gt;
        &lt;/cell&gt;
        &lt;cell hAlign="Full" vAlign="Full"&gt;
          &lt;textLabel label="¿" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell hAlign="Full" vAlign="Full"&gt;
          &lt;checkBox column="RAD_TYPE_BETA" dataSource="V_RRA1" checkedValue="Y" uncheckedValue="N" checked="N"/&gt;
        &lt;/cel</part><part no="2">l&gt;
        &lt;cell hAlign="Full" vAlign="Full"&gt;
          &lt;textLabel label="¿" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell hAlign="Full" vAlign="Full"&gt;
          &lt;checkBox column="RAD_TYPE_GAMMA" dataSource="V_RRA1" checkedValue="Y" uncheckedValue="N" checked="N"/&gt;
        &lt;/cell&gt;
        &lt;cell hAlign="Full" vAlign="Full"&gt;
          &lt;textLabel label="Neutrons" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell hAlign="Full" vAlign="Full"&gt;
          &lt;checkBox column="RAD_TYPE_NEUTRON" dataSource="V_RRA1" checkedValue="Y" uncheckedValue="N" checked="N"/&gt;
        &lt;/cell&gt;
        &lt;cell hAlign="Full" vAlign="Full"&gt;
          &lt;textLabel label="XRay" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell hAlign="Full" vAlign="Full"&gt;
          &lt;checkBox column="RAD_TYPE_XRAY" dataSource="V_RRA1" checkedValue="Y" uncheckedValue="N" checked="N"/&gt;
        &lt;/cell&gt;
      &lt;/row&gt;
      &lt;row height="20"&gt;
        &lt;cell width="200" rowSpan="4" hAlign="Full" vAlign="Full"&gt;
          &lt;textLabel label="Expected Dose Rate [b]" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="2" hAlign="Full" vAlign="Full"&gt;
          &lt;textLabel label="µSvh" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="4" hAlign="Full" vAlign="Full"&gt;
          &lt;textLabel label="Environmental" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="5" hAlign="Full" vAlign="Full"&gt;
          &lt;textLabel label="Contact" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
      &lt;/row&gt;
      &lt;row height="20"&gt;
        &lt;cell columnSpan="2" hAlign="Full" vAlign="Full"&gt;
          &lt;textLabel label="&amp;lt; 7.5" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="4" hAlign="Center" vAlign="Full"&gt;
          &lt;radioButton value="&amp;lt; 7 µsVh" buttonGroup="environment_exp_dose_btngrp"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan</part><part no="3">="5" hAlign="Center" vAlign="Full"&gt;
          &lt;radioButton value="&amp;lt; 7 µsVh" buttonGroup="contact_exp_dose_btngrp"/&gt;
        &lt;/cell&gt;
      &lt;/row&gt;
      &lt;row height="20"&gt;
        &lt;cell columnSpan="2" hAlign="Full" vAlign="Full"&gt;
          &lt;textLabel label="7.5 - 150" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="4" hAlign="Center" vAlign="Full"&gt;
          &lt;radioButton value="7.5 - 150 µsVh" buttonGroup="environment_exp_dose_btngrp"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="5" hAlign="Center" vAlign="Full"&gt;
          &lt;radioButton value="7.5 - 150 µsVh" buttonGroup="contact_exp_dose_btngrp"/&gt;
        &lt;/cell&gt;
      &lt;/row&gt;
      &lt;row height="20"&gt;
        &lt;cell columnSpan="2" hAlign="Full" vAlign="Full"&gt;
          &lt;textLabel label="&amp;gt; 150" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="4" hAlign="Center" vAlign="Full"&gt;
          &lt;radioButton value="&amp;gt; 150 µsVh" buttonGroup="environment_exp_dose_btngrp"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="5" hAlign="Center" vAlign="Full"&gt;
          &lt;radioButton value="&amp;gt; 150 µsVh" buttonGroup="contact_exp_dose_btngrp"/&gt;
        &lt;/cell&gt;
      &lt;/row&gt;
      &lt;row height="20"&gt;
        &lt;cell width="200" hAlign="Full" vAlign="Top"&gt;
          &lt;textLabel label=" " backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="5" hAlign="Full" vAlign="Full"&gt;
          &lt;textLabel label="Contamination Risk" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="6" hAlign="Full" vAlign="Full"&gt;
          &lt;textLabel label="Estimated Max concentration" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
      &lt;/row&gt;
      &lt;row height="80"&gt;
        &lt;cell width="200" hAlign="Full" vAlign="Center" childHeight="80"&gt;
          &lt;textLabel label="Surface contamination arising and spreading [c]" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="5" hAlign="Full" vAlign="Full" childHe</part><part no="4">ight="20"&gt;
          &lt;comboBox displayColumn="LABEL" valueColumn="VALUE" column="SURFACE_CONT_RISK" dataSource="V_RRA1" listDataSource="LOW_MED_HIGH_CB1"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="6" hAlign="Full" vAlign="Full"&gt;
          &lt;textArea wordWrap="Y" column="SURFACE_CONT_ESTIMATE" dataSource="V_RRA1"/&gt;
        &lt;/cell&gt;
      &lt;/row&gt;
      &lt;row height="80"&gt;
        &lt;cell width="200" hAlign="Full" vAlign="Center" childHeight="80"&gt;
          &lt;textLabel label="Liquids being present [c]" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="5" hAlign="Full" vAlign="Full" childHeight="20"&gt;
          &lt;comboBox displayColumn="LABEL" valueColumn="VALUE" column="LIQUID_CONT_RISK" dataSource="V_RRA1" listDataSource="LOW_MED_HIGH_CB1"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="6" hAlign="Full" vAlign="Full"&gt;
          &lt;textArea wordWrap="Y" column="LIQUID_CONT_ESTIMATE" dataSource="V_RRA1"/&gt;
        &lt;/cell&gt;
      &lt;/row&gt;
      &lt;row height="80"&gt;
        &lt;cell width="200" hAlign="Full" vAlign="Center" childHeight="80"&gt;
          &lt;textLabel label="Airborne activity [c]" backgroundColor="lightGray" text-align="Center"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="5" hAlign="Full" vAlign="Full" childHeight="20"&gt;
          &lt;comboBox displayColumn="LABEL" valueColumn="VALUE" column="AIRBORNE_CONT_RISK" dataSource="V_RRA1" listDataSource="LOW_MED_HIGH_CB1"/&gt;
        &lt;/cell&gt;
        &lt;cell columnSpan="6" hAlign="Full" vAlign="Full"&gt;
          &lt;textArea wordWrap="Y" column="AIRBORNE_CONT_ESTIMATE" dataSource="V_RRA1"/&gt;
        &lt;/cell&gt;
      &lt;/row&gt;
    &lt;/tableLayout&gt;
  &lt;/panel&gt;
&lt;/root&gt;
</part></value></editorInstance></component></delta>

in_event_cd : Save
in_objectType_cd : PanelDtl
in_objectIns_oid : 530134
---------------
Thu Nov 5 09:34:02 UTC 2015
RESPONSE XML: (Received in 208ms - Processed in 74ms <47ms javascript, 27ms browser>)
<?xml version="1.0"?>
<app request="122">
    <actions>
        <action oid="530134" objectType="PanelDtl" method="ClearErrors" order="1"/>
        <action oid="530134" objectType="PanelDtl" method="AddError" value="ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00217: invalid character 946 (U+03B2)
Error at line 33" order="1"/>
        <action oid="530134" objectType="PanelDtl" method="SetEditorInstanceDirty" dirty="Y" order="1"/>
        <action oid="530134" objectType="PanelDtl" method="SetEditorInstanceValid" valid="N" order="1"/>
    </actions>
    <ui/>
    <data/>
    <logical/>
</app>
link

answered 05 Nov '15, 05:02

apacheuk's gravatar image

apacheuk
1391223
accept rate: 0%

edited 05 Nov '15, 06:56

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
1.5k5

Hi Simon,

Thanks for your response. Are you experiencing this problem only with α, β, γ characters? For example, I noticed that you are using µ character as the value of a radioButton without problem, did you tried using µ character as the label of any textLabel?

Regards,
Ibrahim

(05 Nov '15, 06:47) Ibrahim Sand... ♦♦

Strangely using that character causes no issue in a label and that shows correctly, which means I'm even more confused :/

(05 Nov '15, 09:23) apacheuk

Hi Simon,

Have you tried to save your panel in any other browser?

Also, to make it sure, can you check that your DB supports β character? You can just create a sample table having some data with β character and create a simple Formspider app where you bind this table to a textField for example.

If the β character is displaying correctly, we can concentrate on the browser and the app server.

(06 Nov '15, 03:03) Ibrahim Sand... ♦♦

Don't have access to any other browsers here due to security restrictions on site.

I've cehcked the DB and there maybe an issue with the NLS settings our DBA is looking in to it, as even inserting a row into a table via SQLplus its translated to a ¿

(06 Nov '15, 07:49) apacheuk
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×1
×1

Asked: 03 Nov '15, 05:15

Seen: 1,053 times

Last updated: 06 Nov '15, 07:50

Related questions


© Copyright Gerger 2017