Simple Select from another PHP project.

[mitring]

I have a problem with a simple SQL query.
I have a file: test.php with db_connect to  Coppermine database.
Simple select to cpg_comments table and I have the wrong encoding.

How to write correnct code to see correct encoding ?

Code Select Expand

SELECT * FROM cpg_comments
and I have:

Code Select Expand

óóóÅ,Å,Å,Å,śśśÄ�

Structure table cpg_comments:

Code Select Expand

CREATE TABLE `jos_chrono_comments` (
 `id` INTEGER(11) NOT NULL AUTO_INCREMENT,
 `component` VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT '',
 `pageid` VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT '',
 `parentid` INTEGER(11) NOT NULL,
 `userid` INTEGER(11) NOT NULL,
 `name` VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT '',
 `email` VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT '',
 `url` VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT '',
 `text` LONGTEXT NOT NULL,
 `datetime` DATETIME NOT NULL,
 `rating` INTEGER(11) NOT NULL,
 `verify` TINYINT(1) NOT NULL,
 `uniqueid` VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT '',
 `published` TINYINT(1) NOT NULL,
 PRIMARY KEY (`id`)
)ENGINE=MyISAM
AUTO_INCREMENT=303 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

[Joachim Müller]

Not related to bridging, moving.
There's too little input in your posting - post more details (i.e. code used). Posting a link to your gallery might help as well. Posting what encoding you chose in coppermine's config could be another thing that potential supporters would like to know. If you want details, post details.