NYCPHP Meetup

NYPHP.org

[nycphp-talk] utf-8, iso-8859-1...

Mona Borham monalisa20042006 at gmail.com
Thu May 6 13:09:07 EDT 2010


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 <chsnyder at gmail.com> wrote:

> On Thu, May 6, 2010 at 12:26 PM, Anthony Wlodarski
> <oneofthosed3afmutes at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20100506/0b0c9cfd/attachment.html>


More information about the talk mailing list