zgkhoo Posted November 1, 2007 Share Posted November 1, 2007 how to change mysql table to UTF8? Link to comment https://forums.phpfreaks.com/topic/75604-solved-how-to-change-mysql-table-to-utf8/ 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 Link to comment https://forums.phpfreaks.com/topic/75604-solved-how-to-change-mysql-table-to-utf8/#findComment-382583 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 Link to comment https://forums.phpfreaks.com/topic/75604-solved-how-to-change-mysql-table-to-utf8/#findComment-382610 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; Link to comment https://forums.phpfreaks.com/topic/75604-solved-how-to-change-mysql-table-to-utf8/#findComment-382616 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.. Link to comment https://forums.phpfreaks.com/topic/75604-solved-how-to-change-mysql-table-to-utf8/#findComment-383366 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 Link to comment https://forums.phpfreaks.com/topic/75604-solved-how-to-change-mysql-table-to-utf8/#findComment-383370 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.