Print

[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]

SELECT * FROM cpg_commentsand I have:

Code: [Select]

óóółłłłśśś�
Structure table cpg_comments:

Code: [Select]

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.