Well sometimes also you should changes the page encoding to UTF-8 which I can't modify as I know except through DreamWeaver and I wanted to know if there is a shortcut for this process rather than opening all the project files and modify the page properties. If anyone has idea please provide us with it.
Thanks, Mona On Thu, May 6, 2010 at 7:59 PM, Chris Snyder <chsny...@gmail.com> wrote: > On Thu, May 6, 2010 at 12:26 PM, Anthony Wlodarski > <oneofthosed3afmu...@yahoo.com> wrote: > > I second, full UTF-8 is awesome down the line for internationalization. > > First see if MySQL even supports UTF-8 on your system, execute: "SHOW > > CHARACTER SET;" and utf8 should appear in the list. Then "ALTER TABLE > > tbl_name CONVERT TO CHARACTER SET charset_name COLLATION > collation_name;". > > Since I have not done this myself I can't verify that it will rebuild > > indexes on the table, I don't think it should but might want to look into > > that as rebuilding indexes on a large table could be time consuming. > > Dirty secret - MySQL latin-1 tables will happily store and retrieve > utf-8 data. They won't sort it correctly, though I believe they will > sort it consistently. > > So even if your MySQL was compiled without unicode support, you can > put utf-8 in and get utf-8 out. > > Of course, if you're going to take the trouble to convert, you should > do it right. > _______________________________________________ > New York PHP Users Group Community Talk Mailing List > http://lists.nyphp.org/mailman/listinfo/talk > > http://www.nyphp.org/Show-Participation >
_______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
