Armand Niculescu, BEng, MSM, is a 34 year old Art Director at Media Division. and he enjoys working with visual arts for film, web and print.

23 responses to “Does your PHP/MySQL app speak Unicode?”

  1. PaulH

    ‘with just a few lines of code, you can “globalize” your online app’ can you now?…what about locales, formatting dates/numbers/currency, handling different calendars, different writing systems, etc.? wow, way to trivialize a whole industry.

  2. Website Builder

    Great post! It’s a bit over my head but I’ll definitely bookmark for later.

  3. Tamuir

    Very nice article Armand, it would be very nice to see more articles on language files, time, date…etc

    Thanks in advance.

  4. Internet Marketing

    Thanks for share. I need this.

  5. bookmark

    I didn’t notice before that non-ASCII characters incompatibility can be solved easily with just additional .UTF-8 table. Thanks for nice and neat solution

  6. Alex Skakunov

    Yeah, nice article. I like the way you explain.

    How column data can be converted to UTF-8 if the imput was in other encoding?

  7. Yokhannan

    You should really try to use “utf8_unicode_ci” and NOT “utf8_general_ci”

    I did not write it, but you should read this guys page for the differences: http://www.davidtan.org/differences-between-utf8_unicode_ci-and-utf8_general_ci/

  8. Emo

    I didn’t notice before that non-ASCII characters incompatibility can be solved easily with just additional .UTF-8 table. Thanks for nice and neat solution

  9. Alex

    Great, it helped me a lot. Thanks…

  10. war games

    Very nice article Armand, it would be very nice to see more articles on this topic.

  11. Ian

    Very clear: thanks! Looks like just what I need, I’ll try it now

  12. Dolls games

    Thanks for good article.

  13. mobile games

    Very good info.Thanks

  14. free online games

    Really nice post thanks for sharing

  15. Funny games

    i am  want to se more articles on this topic…thanks

  16. us drugstore

    Hi, to convert existing tables to UTF8, you use
    ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

  17. Ben O

    Thanks! Those two SQL Queries were what I was missing!

  18. Alex S

    thank you very much!!!

  19. rais

    i got the solution here…. thank you very much Armand……

  20. us drugstore

    Thanks for the review. How column data can be converted to UTF-8 if the imput was in other encoding?