View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 08:36 AM
howa
 
Posts: n/a
Default Should I specify the CHARACTER SET & COLLATE for UTF8 contents?

Since even I use, e.g.

CREATE DATABASE `test_ascii` DEFAULT CHARACTER SET latin1 COLLATE
latin1_swedish_ci;

CREATE TABLE `table` (
`str` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
) ENGINE = innodb;


I can store UTF8 in the DB, even better, I don't need to set names
"utf8" in each
connection, so it is recommended? Any drawbacks?

Thanks.

Reply With Quote