danish letters in textarea

Go to solution

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Søren Reinke 158 posts 206 karma points c-trib

Mar 24, 2011 @ 11:16

Hi there
I have a strange problem with the danish letter æøå in both lower and uppercase.
When i in an Contour form in a textarea enter:

æøåÆØÅ !"#¤%&/()=üäëi¨c

It show up as the following in Entries:

aoaAOA !"#¤%&/()=üäëi¨c

For some weird reason it is only the danish chars that are changed, not the other ones.

The database record in UFRecordsXml is:

<uformrecord>
  <state>Approved</state>
 <created>2011-03-23T14:13:32</created>
  <updated>2011-03-23T14:13:32</updated>
  <id>0e085462-9c21-4a96-95a6-5f26c08f6a5d</id>
   <ip>192.168.4.59</ip>
   <pageid url="/corporate/news/friday-meeting-2011-02-1.aspx" name="Friday meeting 2011-02-1">11322</pageid>
  <memberkey email="[email protected]" login="soren.reinke">9244</memberkey>
  <fields>
      <comment record="0e085462-9c21-4a96-95a6-5f26c08f6a5d" sortorder="0" pageindex="0" fieldsetindex="0">
         <key>d9b38a51-0e1e-4efd-8506-704fcd950b27</key>
         <fieldKey>51fe60ac-e98a-4f6e-9634-4ff7b2aab1f9</fieldKey>
           <caption>Comment</caption>
          <datatype>String</datatype>
         <values>
              <value>
                   <![CDATA[aoaAOA !&quot;#¤%&/()=üäëi¨c]]>
                </value>
          </values>
     </comment>
    </fields>
</uformrecord>

As seen in the 'CDATA' part, the data is stored wrongly in the database.

I have not played around with codepage or anything in the MsSQL database.

In another form i use the 'RecordService_RecordApproved' event to catch the approving of a form, and send the data to a webservice, the webservice receives 'æøåÆØÅ !"#¤%&/()=üäëi¨c' perfectly, but if i look at the entries or directly in the database, the have changed to 'aoaAOA' :-(

Any clues anyone?

I updated to the newest version of Contour yesterday, V 1.1.6 by extracting the 'update' zip file.

Copy Link

Comment author was deleted

Mar 24, 2011 @ 14:54

Thats's strange it's the first report we get of this and I could imagine that it has been used for a lot of danish sites by now, will try to reproduce

Copy Link
Søren Reinke 158 posts 206 karma points c-trib

Mar 24, 2011 @ 14:59

0

I am pretty confused as well ;-)

If I can help you somehow, by providing more information, data/files or anything, or you have something i should test, i will gladly help.

Copy Link
Comment author was deleted

Mar 24, 2011 @ 15:01

Just tested it on a local install and it worked fine, so think it might be an issue with the database settings

Copy Link
Søren Reinke 158 posts 206 karma points c-trib

Mar 24, 2011 @ 15:07

0

I am pretty sure you are right, just tried to change the data directly in the database UFRecordsXml table, it actually get's changed back to 'aoa' instead og 'æøå'

What should the SQL Collation be set to as default?

At the moment it is <database default> which is 'SQL_LATIN1_General_CP1250_CI_AS'

Any idea's what settings could do this?

Copy Link
Søren Reinke 158 posts 206 karma points c-trib

Mar 28, 2011 @ 09:49

0

Tim

Any ideas on what to do?
Or if I need to change anything in the DB ?

Copy Link
Søren Reinke 158 posts 206 karma points c-trib

Mar 28, 2011 @ 10:06

0

Just found the bug.

I added a nvarchar(50) to the table, and æøåÆØÅ worked perfectly.

Then i changed the XML column in UFRecordsXml from 'Text' to 'nText' and it works as well.

Guess the old version of Contour we started to use, has the column type set wrongly. :-)

Copy Link
is working on a reply...

Please Sign in or register to post replies