Topic: mysql collation/character support

question:

i exported some stuff from a mysql database with no collation via phpmyadmin into a text file. i'm running windows.

[code]CREATE TABLE `lucas` (
  `id` mediumint(9) NOT NULL auto_increment,
  `date` int(11) NOT NULL default '0',
  `section` varchar(16) default NULL,
  `body` longtext NOT NULL,
  `hide` enum('t','f') NOT NULL default 'f',
  UNIQUE KEY `id` (`id`),
  KEY `hide` (`hide`),
  FULLTEXT KEY `body` (`body`)
) TYPE=MyISAM PACK_KEYS=0 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=85 ;

INSERT INTO `lucas` (`id`, `date`, `section`, `body`, `hide`) VALUES (28, 1154545025, 'journal', 'went to bed at 1am last night. had a dream. part of it was on the way to the west coast with johnnyg. it was basiclaly d

Re: mysql collation/character support

i tried selecting latin1 as the character set of the file that i'm importing. it preserved the accents.

i don't like this method, though, because i want to be able to import any language.

so is this just a windows limitation, because i pasted the queries into notepad, and my windows charset is latin?

if i download a backup and do not edit it, should i be able to restore it via utf8?