How do you extract multiple languages with special characters when a description is classified as "English"?

Answered

DSP User

• May 30, 2018 16:04

We are extracting multiple languages with special characters successfully, for example, Russian is extracting correctly when classified as "Russian." However, when a description is classified as "English," the Russian texts are coming through as ?. Changing the package to RFC resolves the issue, but I would prefer not to do that for all the description tables. Anyone resolve this previously?

1

• Best answer

  

  DSP User

  • June 15, 2018 11:31

  We switched to the Ole driver for Oracle and that resolved the issue.

  0
• 

  DSP Expert

  • May 30, 2018 16:12

  TEmpson: Hi Alyssa. Do you know what code page the Russian text is encoded with? We had a legacy system where they used western european code page, but then changed the code page on the fly in their application to display Hungarian. We created a way to manipulate this in Collect. Not sure if it is the same situation

  1
• 

  Sailaja Gujjeli

  • October 20, 2021 05:24

  Could you explain the procedure to switch Ole driver ,I am facing the similar issue where the German characters are changing to '?'

  0
• 

  Ben Bauer

  • October 20, 2021 11:38

  Hi Gujjeli,

  The following articles are a bit dated, but the tips about OLE Oracle configuration in our SST/DSP product remain accurate. I hope it helps!

  • https://support.syniti.com/hc/en-us/articles/206445607--Collect-Database-Tips-to-Fixing-Database-Connections-Includes-tips-for-Oracle-DB2-and-Informix-
  • https://support.syniti.com/hc/en-us/articles/205713088--DSP-Oracle-Steps-for-adding-an-Oracle-Database-into-DSP-or-CranSoft

  0

Please sign in to leave a comment.