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. |