[phpReports] Encoding is not in utf-8 , data shown is garbage..
  • VeGaTrOnVeGaTrOn March 2010

    hi

    I'm using utf-8 encoding , and when using phpReports it shows the strings as ??????? !
    I tried setting the encoding of the xml files within the library/phpreports folder but still , no solution

    any ideas
    -----
    BTW a new version of phpReports just released, I think it should be in the next version of SI

  • justinjustin March 2010

    hey VeGaTrOn,

    thanks for posting this

    all new reports are being written without php reports as phpreports has to many issues

    so it'll just be a matter of time before all reports are slowly moved over to plain old php and utf8 should then work all OK

    cheers

    justin

    SmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au
  • VeGaTrOnVeGaTrOn March 2010

    thanks justin..

  • smartcallsmartcall January 2011

    Replace in library/phpreports/database/db_mysql.php the original function with the one below

    function db_query($oCon,$sSQL) {
    mysql_query("set names 'utf8'",$oCon);
    $oStmt = mysql_query($sSQL,$oCon);
    return $oStmt;
    }

  • VeGaTrOnVeGaTrOn January 2011

    thanks smartcall.
    I've solved the problem with php reports a while ago..

    and now I removed the phpreports script entirely form the SI, I have made my own reporting script using plain php, and got ridden of phpreports...

  • anhphuongnnanhphuongnn March 2011

    It's Best Answer.
    Thanks
    Phuong Nguyen

  • fafamongefafamonge July 2011

    Thank you! It works! :-)

Add a Comment

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories