Problem with reading german umlauts

Version 1

    Subject: RE: Problem with reading german umlauts
    Replied by: Florian Kroessbacher on 18-02-2011 08:19:00 AM
    Can u post a AXL debug Trace from that

    I Think there is an ISSUE between UTF-8 and something else on your Website.
    You get UTF-8 Format from the Callmanager.

    In Java i to that

    Get Byte Array
    byte[] lastname_utf8 = endusers_line_parts[2].getBytes("UTF-8");
    Write Byte Array to String
    String lastname = new String(lastname_utf8, "UTF-8");

    to change the Encoding

    cheers

    Subject: RE: New Message from Florian Kroessbacher in Administration XML (AXL) - Adm
    Replied by: Rene Forstner on 18-02-2011 09:06:23 AM
    Hi,

    Here is the trace:

    2011-02-18 14:55:00,883 DEBUG [http-8443-9] axl.ExecuteHandler - select * from speeddial where fkdevice = '63ef3c3e-4e35-9149-48a1-7979deb910ae' order by fkdevice
    2011-02-18 14:55:00,884 DEBUG [http-8443-9] axl.ExecuteHandler - into executeSQLQuery
    2011-02-18 14:55:00,889 DEBUG [http-8443-9] axl.ExecuteHandler - The SQL ResultSet size is723
    2011-02-18 14:55:00,890 DEBUG [http-8443-9] axl.Handler - ColumnCount=6, Row count=3
    2011-02-18 14:55:00,893 INFO  [http-8443-9] axl.AXLRouter - <SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Header/><SOAP-ENV:Body><axl:executeSQLQueryResponse sequence="1234" xmlns:axl="http://www.cisco.com/AXL/API/6.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><return><row><pkid>82fcd75d-1632-5032-4464-3fd415df0623</pkid><fkdevice>63ef3c3e-4e35-9149-48a1-7979deb910ae</fkdevice><speeddialindex>1</speeddialindex><speeddialnumber>0000</speeddialnumber><label>ÿÿÿüöä</label><labelascii>Franz</labelascii></row><row><pkid>9032c82b-9e6d-bc31-fd8a-c5adaf425bf5</pkid><fkdevice>63ef3c3e-4e35-9149-48a1-7979deb910ae</fkdevice><speeddialindex>2</speeddialindex><speeddialnumber>0000</speeddialnumber><label>äöäüäöä</label><labelascii>Franz Mobil</labelascii></row><row><pkid>63daeb57-3820-bbca-ec19-75031c7c270a</pkid><fkdevice>63ef3c3e-4e35-9149-48a1-7979deb910ae</fkdevice><speeddialindex>3</speeddialindex><speeddialnumber>0000</speeddialnumber><label>Philipp</label><labelascii>Philipp</labelascii></row></return></axl:executeSQLQueryResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>
    2011-02-18 14:55:00,894 INFO  [http-8443-9] servletRouters.AXLAlpha - Request processed by AXL
    2011-02-18 14:55:00,895 INFO  [http-8443-9] servletRouters.AXLFilter - <?xml version="1.0" encoding="ISO-8859-1" ?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Header/><SOAP-ENV:Body><axl:executeSQLQueryResponse sequence="1234" xmlns:axl="http://www.cisco.com/AXL/API/6.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><return><row><pkid>82fcd75d-1632-5032-4464-3fd415df0623</pkid><fkdevice>63ef3c3e-4e35-9149-48a1-7979deb910ae</fkdevice><speeddialindex>1</speeddialindex><speeddialnumber>0000</speeddialnumber><label>������</label><labelascii>Franz</labelascii></row><row><pkid>9032c82b-9e6d-bc31-fd8a-c5adaf425bf5</pkid><fkdevice>63ef3c3e-4e35-9149-48a1-7979deb910ae</fkdevice><speeddialindex>2</speeddialindex><speeddialnumber>0000</speeddialnumber><label>�������</label><labelascii>Franz Mobil</labelascii></row><row><pkid>63daeb57-3820-bbca-ec19-75031c7c270a</pkid><fkdevice>63ef3c3e-4e35-9149-48a1-7979deb910ae</fkdevice><speeddialindex>3</speeddialindex><speeddialnumber>0000</speeddialnumber><label>Philipp</label><labelascii>Philipp</labelascii></row></return></axl:executeSQLQueryResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>
    2011-02-18 14:55:00,895 INFO  [http-8443-9] servletRouters.AXLFilter - Request 1296028445021 was process in 27ms

    I changed the service parameter ¿Send Encoding Information in AXL¿ to true, so I can see the encoding <?xml version="1.0" encoding="ISO-8859-1" ?>

    Kind regards
    René

    From: Cisco Developer Community Forums [mailto:cdicuser@developer.cisco.com]
    Sent: Friday, February 18, 2011 2:19 PM
    To: cdicuser@developer.cisco.com
    Subject: New Message from Florian Kroessbacher in Administration XML (AXL) - Administration XML Questions: RE: Problem with reading german umlauts

    Florian Kroessbacher has created a new message in the forum "Administration XML Questions":

    --------------------------------------------------------------
    Can u post a AXL debug Trace from that

    I Think there is an ISSUE between UTF-8 and something else on your Website.
    You get UTF-8 Format from the Callmanager.

    In Java i to that

    Get Byte Array
    byte[] lastname_utf8 = endusers_line_parts[2].getBytes("UTF-8");
    Write Byte Array to String
    String lastname = new String(lastname_utf8, "UTF-8");

    to change the Encoding

    cheers
    --
    To respond to this post, please click the following link:

    <http://developer.cisco.com/web/axl/forums/-/message_boards/view_message/3073590>

    or simply reply to this email.
    The information contained in this e-mail message is privileged and
    confidential and is for the exclusive use of the addressee. The person
    who receives this message and who is not the addressee, one of his
    employees or an agent entitled to hand it over to the addressee, is
    informed that he may not use, disclose or reproduce the contents
    thereof, and is kindly asked to notify the sender and delete the e-mail
    immediately.

    Subject: RE: New Message from Florian Kroessbacher in Administration XML (AXL) - Adm
    Replied by: Florian Kroessbacher on 18-02-2011 10:17:04 AM
    Hy out there,

    i've done the follwing -> copy the Respones to notepad++ -> Default Encoding vor me is ANSI in notepad+++

    Copy from rom this Response "2011-02-18 14:55:00,893 INFO [http-8443-9]"

    So after the Copy to notepad the label looks like this

    <label>ÿÿÿüöä</label>

    After changing the Format to UTF-8 the label looks like this

    <label>ÜÖÄüöä</label>

    The Service Parameter is set to false in our environment so i think we always get UTF-8.

    Why don't to a UTF-8 encoding off the Website

    cheers
    This document was generated from CDN thread

    Created by: Rene Forstner on 18-02-2011 08:12:51 AM
    Hi,
     
    If i want to read a table from the database (like <sql>select * from speeddial</sql>) and in a label field is a german ö,ü,ä i just see "?" instead of the letter.
     
    The tool is written with C# in the Visual Studio 2008.
     
    Below is the code snippet, which reads the webresponse stream
    Codepage 28591 is the iso-2859-1 codepage(The AXL Response told me so), unicode, utf8 or something else does not work.
     
     
     
     

    <font size="2">
     
    </font>
     
    Encoding enc = System.Text.Encoding
    .GetEncoding(28591);<font size="2">
     
    </font>
     
    StreamReader loResponseStream =
    new
    <font size="2">
     
    </font>
     
    StreamReader
    (webresponse.GetResponseStream(), enc);<font size="2">
     
    </font>
     
    string
    Response = loResponseStream.ReadToEnd();


     
    Does anybody know this issue? Is something wrong with my encoding or may a problem from the AXL SOAP?
     
    kind regards
    rené

    Subject: RE: Problem with reading german umlauts
    Replied by: Rene Forstner on 04-03-2011 06:39:01 AM
    Hi,

    Sorry for my late response.

    Seems that the problem are the windows codepages.

    I get the stream utf-8 encoded.
    If the tool is running on a german windows installation the umlauts are correct. Is the win installation english, I only get "???" or the chars, you can see in the traces.
    The strange thing is, that all necessary codepages are installed on the english windows installation.
    Meanwhile the branch in the Czech Republic is also enrolled, now we have more than the few german umlauts, like é à and so on.

    I'll let you know, if I have a solution for this problem.

    cheers
    rené

    Subject: RE: Problem with reading german umlauts
    Replied by: Stefan Schallmeiner on 04-03-2011 07:20:08 AM
    Hi Rene!

    I guess that's because of the Environment-Variables of the different Windows-Versions, UTF-8 Strings that are interpreted as ISO-8859-1 look something like this: öüöüöäöü

    And ISO-8859-1 Strings that are interpreted as UTF-8 result in ???-marks,...

    So i guess the standard encoding of your german windows version is ISO-8859-1 and of your czech windows version is UTF-8. So the Solution would be to get the Standard-Encoding via environment Variables in your tool and decode/encode to the right encoding of the target machine.


    We had something similar these days with windows and linux, standard encoding under our windows environment is iso8859-1 and under linux most of the time utf-8,...