zgkhoo Posted November 1, 2007 Share Posted November 1, 2007 how to change mysql table to UTF8? Quote Link to comment Share on other sites More sharing options...
~n[EO]n~ Posted November 1, 2007 Share Posted November 1, 2007 ALTER DATABASE `dbname` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci Quote Link to comment Share on other sites More sharing options...
zgkhoo Posted November 1, 2007 Author Share Posted November 1, 2007 how about initially create of db and create table? how to add in this setting in create clause. thanks a lot Quote Link to comment Share on other sites More sharing options...
~n[EO]n~ Posted November 1, 2007 Share Posted November 1, 2007 Like this CREATE DATABASE `likethis` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; Quote Link to comment Share on other sites More sharing options...
zgkhoo Posted November 2, 2007 Author Share Posted November 2, 2007 `likethis` <--this one database name? y got use ' ??? wat for? thanks.. Quote Link to comment Share on other sites More sharing options...
~n[EO]n~ Posted November 2, 2007 Share Posted November 2, 2007 You can leave that ' ' , if you want Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.