KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Arabic character showing junk #2628

Open Balamurugan opened this topic on on Apr 4, 2022 - 3 comments

Balamurugan commented on Apr 4, 2022

We tried to create arabic report by using koolreport , static data is showing arabic but dynamic data is showing as junk characters. We are using oracle as database and php for development . Pls help

Sebastian Morales commented on Apr 5, 2022

Which charset does your Oracle database use? Pls open the file koolreport/core/src/datasources/OracleDataSource.php and replace the following line:

    $conn = oci_connect($username, $password, $connString, "", $session_mode);

with this one:

    $conn = oci_connect($username, $password, $connString, "UTF-8", $session_mode); // if your database uses a charset other than UTF-8 replace "UTF-8" with it.
Balamurugan commented on Apr 5, 2022

we tried and below error

Invalid character set UTF-8 , but we are using UTF-8

Sebastian Morales commented on Apr 5, 2022

Ok, then pls try "AL32UTF8" and see how it goes:

    $conn = oci_connect($username, $password, $connString, "AL32UTF8", $session_mode);

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
None yet

None