Re: 㶠instead of ü
Hi Peter,
thank you for your response!
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir C:\Parallels\Plesk\Databases\MySQL51\share\charsets\
CREATE TABLE `pictures` (
`pid` int(11) NOT NULL AUTO_INCREMENT,
`aid` int(11) NOT NULL DEFAULT '0',
`filepath` varchar(255) NOT NULL DEFAULT '',
`filename` varchar(255) NOT NULL DEFAULT '',
`filesize` int(11) NOT NULL DEFAULT '0',
`total_filesize` int(11) NOT NULL DEFAULT '0',
`pwidth` smallint(6) NOT NULL DEFAULT '0',
`pheight` smallint(6) NOT NULL DEFAULT '0',
`hits` int(10) NOT NULL DEFAULT '0',
`mtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ctime` int(11) NOT NULL DEFAULT '0',
`owner_id` int(11) NOT NULL DEFAULT '0',
`pic_rating` int(11) NOT NULL DEFAULT '0',
`votes` int(11) NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`caption` text NOT NULL,
`keywords` varchar(255) NOT NULL DEFAULT '',
`approved` enum('YES','NO') NOT NULL DEFAULT 'NO',
`galleryicon` int(11) NOT NULL DEFAULT '0',
`user1` varchar(255) NOT NULL DEFAULT '',
`user2` varchar(255) NOT NULL DEFAULT '',
`user3` varchar(255) NOT NULL DEFAULT '',
`user4` varchar(255) NOT NULL DEFAULT '',
`url_prefix` tinyint(4) NOT NULL DEFAULT '0',
`pic_raw_ip` tinytext,
`pic_hdr_ip` tinytext,
`lasthit_ip` tinytext,
`position` int(11) NOT NULL DEFAULT '0',
`guest_token` varchar(32) DEFAULT '',
`price` text NOT NULL,
`option` text NOT NULL,
PRIMARY KEY (`pid`),
KEY `owner_id` (`owner_id`),
KEY `pic_hits` (`hits`),
KEY `pic_rate` (`pic_rating`),
KEY `aid_approved` (`aid`,`approved`),
KEY `aid` (`aid`),
KEY `pic_aid` (`aid`,`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=29146 DEFAULT CHARSET=utf8 COMMENT='Used to store data about individual pics'