设置数据库字符集为utf8,mysql字符集utf8mb4

iknowthatmysqlhasdefaultoflatin1encodingandapparentlyittakes1bytetostoreacharacterinlatin1and3bytestostoreacharacterinutf-8

iamworkingonasitethatihopewillbeusedglobally.doiabsolutelyneedtohaveutf-8？ orwillibeabletogetawaywithusinglatin 1？

Also，itriedtochangesometablesfromlatin1to utf8 butigotthiserror :

doesanyoneknowthesolutiontothis？ andshouldireallysolvethatormaylatin1be enough？

Thanks，

klddw/p

it takes1bytestostorealatin1character and1 to3bytestostoreazjdbbzcharacter。

ifyouonlyusebasiclatincharactersandpunctuationinyourstrings (0to 128 in unicode )，bothcharsetswillocccupythesamelength。

Also，itriedtochangesometablesfromlatin1to utf8 butigotthiserror 3360 ' speficiefkeywastoolong； maxkeylengthis 1000 bytes ' doesanyoneknowthesolutiontothis？ andshouldireallysolvethatormaylatin1be enough？

ifyouhaveacolumnofvarchar(334 ) or longer，myisam wont ' tletyoucreateanindexonitsincethereisremoteposibilityofthecolumntochochontochonther

notethatkeysofsuchlengtharerarelyuseful.youcancreateaprefixedindexwhichwillbealmostasselectiveforanyreal-world数据。