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 over 2 years ago