Normal Topic Umlaut getting lost (Read 1453 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Umlaut getting lost
Feb 17th, 2012 at 2:20pm
Print Post Print Post  
Hi experts!
I have to read or to import a XML - file in Sesame.
Reading The XML - file still contains all umlaut characters, but after the import in Sesame not...
Can somebody advise me how I can keep the special characters?

Thanks
Belhareth
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Umlaut getting lost
Reply #1 - Feb 18th, 2012 at 3:27am
Print Post Print Post  
Which version of Sesame are you using, and what method are you using to get the data into Sesame? Are you using the import facility, or are you reading the file with SBasic?

I just tested Ä, Ö, and Ü. They imported perfectly. And they also were read by @Insert() perfectly.

Though, when I read them in with @XMLNodeValue(), I did get some funny results. They came into Sesame as:
Ä
Ö
Ã

Are you seeing this, or something else?
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: Umlaut getting lost
Reply #2 - Feb 18th, 2012 at 11:19am
Print Post Print Post  
Hello Carl!
Wen i export a form to XML, and import it again in a different application, the umlaut does not play correctly.

i use Sesame 2.5.2

Thansks.
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Umlaut getting lost
Reply #3 - Feb 18th, 2012 at 4:21pm
Print Post Print Post  
Exactly how are you exporting/importing the XML? Are you using SBasic XML commands?

Or are you using some of the following XML Utilities?
Export Application to XML
XML Database
Export Design to XML
Export Layouts to XML
Import Layouts from XML

Are the missing characters part of the data, or part of the design?
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: Umlaut getting lost
Reply #4 - Feb 18th, 2012 at 5:25pm
Print Post Print Post  
Hello!
In Seesame Design I use export Form to XML, Export Report to XML, Import XML Form and Import XML Report

The missing (modified) characters are part of the design.

Thanks.
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Umlaut getting lost
Reply #5 - Feb 19th, 2012 at 2:42am
Print Post Print Post  
Okay, a little research on the Internet reveals that this is a known issue with the format the XML is encoded in.

I was able to fix the issue you are seeing, simply by changing the first line in the XML file (just before importing it into Sesame) from this:
<?xml version="1.0" encoding="ISO-8859-1"?>

to this:
<?xml version="1.0" encoding="UTF-8"?>

Now, I don't know what other consequences this may have, but it does allow the umlaut characters to be imported correctly. I'm hoping someone else might have some deeper insight into this.
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Umlaut getting lost
Reply #6 - Feb 19th, 2012 at 3:31am
Print Post Print Post  
In Sesame, it depends on how the umlaut character got there in the first place. If it was produced using the Sesame deadkey sequence, Sesame will produce an older 8859-1/15 code. If the character was produced using the OS deadkey sequence, it is likely that the multi-byte UTF-8/Unicode sequence was produced. Sesame has some support for UTF-8, though it is not as complete as our 8859-1/15 code page support. In this case, it looks like Amor produced UTF-8 codes and exported them in XML as 8859-1.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged