Fixing encoding issues in MySQL

Symptom

Encountering character encoding issues when using MySQL database as a repository for 360Eyes.

Environment

  • 360Eyes
  • SAP BusinessObjects Enterprise XI 3.1
  • SAP BusinessObjects Business Intelligence 4.0
  • SAP BusinessObjects Business Intelligence 4.1
  • SAP BusinessObjects Business Intelligence 4.2
  • SAP BusinessObjects Business Intelligence 4.3

Resolution

 add the following DBurl string parameters to solve the problem:

  • useUnicode=yes
  • characterEncoding=utf8

DBurl syntax:

DBurl = jdbc:mysql://<server>:<port>/<database>?useUnicode=yes&characterEncoding=utf8

Keywords

logging, log, Business Objects, BusinessObjects, BIP, Business Intelligence Platform

Product

Product or Product version
  • 360Eyes

Languages

  • English

Last updated almost 2 years ago