Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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
  • 1,354 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