Uniface User Forum

 View Only
Back to discussions
Expand all | Collapse all

0xA0 character from the Database is not recognized during processing in the component

  • 1.  0xA0 character from the Database is not recognized during processing in the component

    Posted 11-17-2022 07:23
    Hi,

    I have issue with processing 0xA0 (no break space) character in Uniface. The data are stored in the DB. EWhen retrieving the data and trying to process in component I have only empty string in my variable. Do you know how to fix it? When the space is normal 0x20 ASCII then it works fine.

    BR,
    Jozef

    ------------------------------
    Jozef Prokopovic
    Uniface Community Edition Shared Account
    US
    ------------------------------


  • 2.  RE: 0xA0 character from the Database is not recognized during processing in the component

    ROCKETEER
    Posted 11-18-2022 06:23
    Edited by David Akerman 11-18-2022 06:29

    Hi Jozef,

    Some questions:

    How is the field defined? Is it a string or a binary (raw) field? If it is a string, does it use a Unicode packing code (e.g. W or VW instead of C or VC)? Mapping can also be modified by Database Connector settings, e.g. https://www3.rocketsoftware.com/rocketd3/support/documentation/Uniface/104/uniface/dbmsSupport/dbmsDrivers/_common/options/nls.htm

    Does the field have the MUL syntax?

    How is the field defined in the database and what type of intermediate variables are you using to process the data (if any)?

    For more relevant information, also see the Description topic in the $DEF_CHARSET documentation.

    Regards,

    ------------------------------
    David Akerman
    Subject Matter Expert
    Rocket Internal - All Brands
    ------------------------------

    Original Message