By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,694 Members | 1,294 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,694 IT Pros & Developers. It's quick & easy.

phpMyAdmin and MySQL connection collation

P: n/a
DH
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
Jul 17 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.