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!

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

This is the sixth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...