Splunk Enterprise

Why is the text not outputting normally when trying to access DB using latin1?

lifekis
Explorer

Hello,

I am trying to access DB using latin1 character as DB connector.
However, the text is not output normally.
I tried the following through JDBC URL in DB connection, but still no normal output.
jdbc:mysql://<ip>:<port>/<database>?characterEncoding=latin1
jdbc:mysql://<ip>:<port>/<database>?useUnicode=true&characterEncoding=latin1
jdbc:mysql://<ip>:<port>/<database>?useUnicode=true&characterEncoding=utf8
jdbc:mysql://<ip>:<port>/<database>?useUnicode=yes&characterEncoding=UTF-8

could you help me?

 

MySQL version: 5.1

image.png

0 Karma
Get Updates on the Splunk Community!

Build Scalable Security While Moving to Cloud - Guide From Clayton Homes

 Clayton Homes faced the increased challenge of strengthening their security posture as they went through ...

Mission Control | Explore the latest release of Splunk Mission Control (2.3)

We’re happy to announce the release of Mission Control 2.3 which includes several new and exciting features ...

Cloud Platform | Migrating your Splunk Cloud deployment to Python 3.7

Python 2.7, the last release of Python 2, reached End of Life back on January 1, 2020. As part of our larger ...