Issue with character encoding importing from an Oracle server using JDBC connection and mid-server.

ebarrette
Tera Contributor

‎03-21-2025 08:18 AM

Hi,

 

I have configured a Data Source using a JDBC connection to an Oracle database using a mid-server.

 

I loaded 20 test records and I can already see issue with some French characters. For example:

 

"ON-Édifice Joseph Shepard" comes out as "ON-Édifice Joseph Shepard"

 

The Oracle character set are:
nls_characterset: WE8ISO8859P1

nls_nchar_characterset: AL16UTF16

Any idea on how to resolve this?

 

Thanks,

Eric

0 Helpfuls
  • 825 Views
2 REPLIES 2

Antti Luusua
Kilo Guru

‎04-22-2025 02:02 AM

We are currently experiencing quite similar issue, but with MS SQL server JDBC connections. Did you ever find a solution?

0 Helpfuls

Simon78
Tera Contributor

‎04-25-2025 06:19 AM

It might be related to this https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB2053730

0 Helpfuls