Ответ

Anti 17.10.2007 13:28 / 17.10.2007 13:29

У таблицы кодировка не указана

DROP TABLE IF EXISTS sun_resources;
CREATE TABLE sun_resources (
  id int(10) unsigned NOT NULL auto_increment,
  uuid varchar(40) NOT NULL default '',
  name varchar(32) NOT NULL default 'noname',
  title varchar(64) NOT NULL default 'noname',
  body text,
  list text,
  processed tinyint(1) unsigned NOT NULL default '0',
  created datetime default NULL,
  modified datetime default NULL,
  attrib tinyint(3) unsigned NOT NULL default '0',
  lang varchar(5) NOT NULL default '',
  cluster char(3) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY name (name)
) TYPE=MyISAM;

--
-- Dumping data for table `sun_resources`
--

INSERT INTO sun_resources VALUES (1,'DDD689C5-E747-4E49-A8B6-E192A0A91AF4','copyright','noname','© Dmitry Litvinenko','',0,NULL,NULL,3,'','');

Вот переменные:

character_set_client utf8
character_set_connection koi8r
character_set_database koi8r
character_set_results utf8
character_set_server koi8r
character_set_system utf8
collation_connection koi8r_general_ci
collation_database koi8r_general_ci
collation_server koi8r_general_ci


какая-то бодяга с koi8r
что бы с ней сделать?

?charset=utf8 - нет эффекта
^void:sql{SET CHARACTER SET UTF8} - нет эффекта

---