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
Languages
Related Articles
Database Debug Mode (on Microsoft Windows)
Condition Database issues arise and detailed logs are needed for debugging and fixing problems. Solution Cause The database may be corrupted or other technical issues arise. Remedy 1. Open a Windows command line or PowerShell prompt. 2. Access the ...
JDBC drivers matrix
DataBase Management System (DBMS) JDBC driver names PostgreSQL postgresql-xx.x.xx.jar Oracle ojdbcX.jar MySQL mysql-connector-java-x.x.xx.jar Microsoft SQL Server mssql-jdbc-x.x.xx.jar SAP Hana ngdbc.jar SAP Sybase / SQL Anywhere jconn4.jar ...
Known Limitations for 360Suite on BI2025
Context 360Suite can properly connect to BI2025 and perform all functions available in previous versions. However, there are issues with the new "widx" format and the new tables and charts introduced in this version. This knowledge base documents all ...
Read Tomcat Logs after 2025.1 upgrade
Context 2025.1 made a lot of changes regarding log generation. Allowing users and support agent to be more efficient in the search of issues. The 360Suite Tomcat will now generate new files if old one are getting too large, this will only happen on ...
FAQ: Migrate to the new 360Eyes for SAP BusinessObjects Audit Job
Context Version 2025.2 introduced changes to the behavior of 360Eyes Jobs. Previously, we had a list of jobs consisting of: - CMS - Webi - Crystal - Universe - IA & Other Each job had an option to extract audit information. This could sometimes lead ...