I have read the forum post and documentation about supported character sets of an external Oracle database.
However, I have a situation where I integrate with an Oracle database that has set its Characterset property to 'US7ASCII'. We see that special characters (for example é and à) are shown as question marks (even in View data).
Since the database is also used by other applications, it's probably not an option to change the characterset property.
Is there any way to correct the conversion?
Thanks,
Remco
Remco,
you can use the oracle function convert
select ....., convert(column-name,'us7ascii','utf8') as ......,
from ....
CONVERT(string_expression,to_data_set[,from_data_set]);
you can read from the docs
https://docs.oracle.com/database/121/SQLRF/functions041.htm#SQLRF00620
Common character sets
Character SetDescriptionAL32UTF8Unicode 5.0 Universal character set UTF-8 encoding formEE8MSWIN1250Microsoft Windows East European Code Page 1250JA16SJISTILDEJapanese Shift-JIS Character Set, compatible with MS Code Page 932US7ASCIIUS 7-bit ASCII character setUTF8Unicode 3.0 Universal character set CESU-8 encoding formWE8EBCDIC1047IBM West European EBCDIC Code Page 1047WE8ISO8859P1ISO 8859-1 West European 8-bit character setWE8MSWIN1252Microsoft Windows West European Code Page 1252ZHT16MSWIN950Microsoft Windows Traditional Chinese Code Page 950
Hope it helps you
Best regards
Carl Ruhle
I would like to reopen this discussion. The approach from Carl works, but is very inconvenient since it requires us to change multiple aggregates to SQL queries which makes us loose many aggregate-benefits. Additionally, we would like to solve the issue at the level of the integration to the external database.
Is there any option to already convert the charset when connecting to the external database, e.g. via Integration Studio?