Skip to main content
To homepage To homepage
Solved

Special Character Encoding Issues with Swedish Characters in ODBC Oracle Integration

  • December 16, 2024
  • 2 replies
  • 34 views
oscarcleve
Contributor
Forum|alt.badge.img+1

Hello,

I'm facing an issue with how TimeXtender handles special Swedish characters (å, ä, ö) when querying data from an Oracle database through the ODBC data source. 

I have a view that contains a column with the data type (VARCHAR2) in the Oracle DB. When loading the data to TimeXtender the special characters appear as question marks (å), a (ä), and o (ö).

 

 

However, when I create a Query Table and use CAST(CF$_PLAN AS VARCHAR2(1000)) on the same column the special characters are retrieved correctly to TimXtender. 

 

 

I have queried DUMP from the database to check that the column’s special characters are stored with proper UTF-8 encoded values, and they are.

I have also checked the NLS settings for the Oracle database, the TX application server and the ODBC connection.

Is there a way for these special characters to be retrieved correctly to TimeXtender without having to use CAST in Query Tables?

I use TimeXtender Data Integration 6822.1 and TimeXtender Ingest Service 6823.1. The ODBC Driver used is Oracle in instantclient_23_6 64-bit.

Best answer by rory.smith

Hi,

 

perhaps this https://stackoverflow.com/questions/53780855/how-to-get-special-characters-using-an-odbc-source-to-an-oracle-database-using-c gives a solution that works.

View original
Pontus Olausson
1 person likes this
  • Pontus Olausson
    Pontus Olausson
Did this topic help you find an answer to your question?

2 replies

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • rory.smith
  • TimeXtender Xpert
  • 649 replies
  • Answer
  • December 16, 2024

Hi,

 

perhaps this https://stackoverflow.com/questions/53780855/how-to-get-special-characters-using-an-odbc-source-to-an-oracle-database-using-c gives a solution that works.

Christian Hauggaard
oscarcleve
2 people like this
  • Christian Hauggaard
    Christian Hauggaard
  • oscarcleve
    oscarcleve
oscarcleve
Contributor
Forum|alt.badge.img+1
  • oscarcleve
  • Author
  • Contributor
  • 13 replies
  • December 16, 2024

Thank you ​@rory.smith, it seems like the solution in the link you provided did the trick. I think the problem was that I had set the NLP_LANG environment variable on the user lever rather than at the system level. 

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings