I must work with phpMyAdmin 2.6.0-pl3 installed on a client's Windows NT
web server. I've not previously encountered options for charset and
collation using phpMyAdmin, and am not sure what to set "MySQL
connection collation" for English-US type usage.
The default MySQL charset: UTF-8 Unicode (utf8)
I didn't notice this until exporting a backup, which for different
tables is giving me different "CHARSET=latin1 " values.
Maybe I need to export existing work, manually remove the CHARSET
settings from the schema and re-insert it back into phpMyAdmin?????
CREATE TABLE `code_library` (
`id` mediumint(6) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`purpose` varchar(255) NOT NULL default '',
`clip` text NOT NULL,
`date_entered` date NOT NULL default '0000-00-00',
`time_entered` time NOT NULL default '00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
UNIQUE KEY `name_2` (`name`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT= 2 ;
TIA
web server. I've not previously encountered options for charset and
collation using phpMyAdmin, and am not sure what to set "MySQL
connection collation" for English-US type usage.
The default MySQL charset: UTF-8 Unicode (utf8)
I didn't notice this until exporting a backup, which for different
tables is giving me different "CHARSET=latin1 " values.
Maybe I need to export existing work, manually remove the CHARSET
settings from the schema and re-insert it back into phpMyAdmin?????
CREATE TABLE `code_library` (
`id` mediumint(6) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`purpose` varchar(255) NOT NULL default '',
`clip` text NOT NULL,
`date_entered` date NOT NULL default '0000-00-00',
`time_entered` time NOT NULL default '00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
UNIQUE KEY `name_2` (`name`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT= 2 ;
TIA