Skip to main content

ACUXDBC column data format(varchar/nvarchar) Language/characters

  • September 22, 2015
  • 1 reply
  • 0 views
D

Hey.

I am struggeling with what I suspect to be a XFD-definition problem.

The "sql" data format of text columns is somehow wrong. It cannot display Norwegian characters, which is a problem for me. The format is now varchar(30) which is a non-Unicode format. I am not sure if changing to e.g. nvarchar wil help me, but its the first thing I can think of.

Have any of you got any ideas of how to extract text-fields with international(Norwegian) characters?


#Extend9
#extend
#fd
#XFD
#AcuXDBC
#linkedserver
#encoding

    1 reply

    Stephen Hjerpe
    • Stephen Hjerpe
    • Participating Frequently
    • September 23, 2015

    Hey.

    I am struggeling with what I suspect to be a XFD-definition problem.

    The "sql" data format of text columns is somehow wrong. It cannot display Norwegian characters, which is a problem for me. The format is now varchar(30) which is a non-Unicode format. I am not sure if changing to e.g. nvarchar wil help me, but its the first thing I can think of.

    Have any of you got any ideas of how to extract text-fields with international(Norwegian) characters?


    #Extend9
    #extend
    #fd
    #XFD
    #AcuXDBC
    #linkedserver
    #encoding

    Version 10 GA date is Sept 24 2015 .

    SUBJECT: Different characters sets showing incorrectly in a query

    Change Number:  ECN-XD101

    New Version: 10.0.0

    If an application such as Microsoft query attempts to read data files containing OEM characters, the data would not display correctly. A new configuration variable has been introduced that will translate entered

    data to and from the ANSI and the OEM character set.

    OEM_CHARACTER_SET

    Setting this variable to ON(TRUE, YES), causes XDBC to call a function that will translate the ANSI character set to the OEM character set.  Data being read will be translated from the OEM character set to the ANSI character set.

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement