Caption provided by cpmfetch does not show UTF-8 characters correctly Caption provided by cpmfetch does not show UTF-8 characters correctly
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

Caption provided by cpmfetch does not show UTF-8 characters correctly

Started by vivison, February 06, 2008, 05:13:45 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

vivison

I'm using cpmfetch 2.0.0 within SMF 1.1.2 and coppermine-gallery 1.4 to show last 6 pics with caption as alt tag in SMF header session. (They look nice! Thanks cpmfetch for such a cool tool.) However, the caption fails to show Vietnamese correctly. SMF and coppermine gallery have no problem displaying the Vietnamese caption. I did change all encoding references to utf8 but no cigar! Please advice on what could be the cause of this display problem.
Thanks and regards.

vivison

It works (displaying Vietnamese correctly) if I added:

mysql_query('SET NAMES utf8');

before:

$resultset = mysql_query($sqlcode, $this->dbconnection);

Please refer to function dbExecuteSql($sqlcode, $convert=true) (in cpmfetch_dao.php) for the subject line of code.