Fixing encoding issues in MySQL

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

    • 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 ...

    • "Invalid tag: FORMAT_DICT" error

      Symptoms After upgrading a BusinessObjects (BOBJ) environment, you may encounter the error with 360Suite feature like 360Cast or 360Bind: Unexpected exception: Failed to parse document. Invalid tag: FORMAT_DICT These features typically work with ...

    • Unable to change the password for the Administration Console (Windows)

      Symptoms Install or update 360Suite with Tomcat running as a Windows service. Attempt to launch or interact with the 360Suite Administration Console. Notice that the console does not load properly or crashes silently. Cause The Windows user account ...

    • 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 ...