Help with UTF8 and eZDB:instance problem needed

Wednesday 13 February 2008 9:54:19 am

Hi,

I'm developing contribution for eZ Publish ver. 4.0. The problem is displaying of greman chars.
When I use code:

$db =& eZDB::instance();  
$query = "SELECT * FROM ...";
$ResultArray =& $db->arrayQuery( $query );
$out .= $ResultArray[0][$language];

The output is : Französisch.

When i replace the code above with this code:

mysql_connect('localhost', 'admin', '*****');
mysql_select_db('****');
$row = mysql_fetch_array(mysql_query("SELECT * FROM ...")); 
$out .= $row['$language']); 

The output is: Französisch.

Why first example doesn't work?

Thanks,
b_segic

Wednesday 13 February 2008 9:54:02 pm

There's too little context, but that's looks like invalid connection encoding was used to input the data or is skipped when connecting. Normally, before you work with UTF8 DB, you should call 'SET NAMES utf8' query (this is done automatically by eZ Publish db libs, I believe). When you establish your own connection and send query, it's most probably latin encoding by default, which is why your data seems fine.

Hint: use PHPMyAdmin, choose any UTF-8-like language and utf8_general_ci collation (just in case) and look at the data.

PS. Also, not sure if those references are needed there...

Good luck!

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu