Re: [PHP] question about database field-types and special characters

2008-02-18 Thread Richard Lynch
On Thu, February 14, 2008 8:47 pm, Rob Gould wrote: Should I have used utf-8 instead? Yes. And you need to convince not only the MySQL server to use UTF-8, but also the MySQL client compiled into your PHP to use UTF-8. -- Some people have a gift link here. Know what I want? I want you to buy

Re: [PHP] question about database field-types and special characters

2008-02-15 Thread tedd
At 12:10 AM -0500 2/15/08, Robert Cummings wrote: Or, and this is what I would do, convetr your database to UTF-8. That way you're prepared for the rest of the world. In this day and age I would creat a site with anything but UTF-8. Wouldn't create a site with anything but UTF-8.

[PHP] question about database field-types and special characters

2008-02-14 Thread Rob Gould
I've got a PHP application that pulls in data from a mySQL database. The data is a series of wine producers, and many of them have special foreign characters over the a's and o's. When I go and view the data from my database using myPHPAdmin, the characters look fine, but when I pull the

Re: [PHP] question about database field-types and special characters

2008-02-14 Thread Robert Cummings
On Thu, 2008-02-14 at 18:47 -0800, Rob Gould wrote: I've got a PHP application that pulls in data from a mySQL database. The data is a series of wine producers, and many of them have special foreign characters over the a's and o's. When I go and view the data from my database using

Re: [PHP] question about database field-types and special characters

2008-02-14 Thread Robert Cummings
On Thu, 2008-02-14 at 23:59 -0500, Robert Cummings wrote: On Thu, 2008-02-14 at 18:47 -0800, Rob Gould wrote: I've got a PHP application that pulls in data from a mySQL database. The data is a series of wine producers, and many of them have special foreign characters over the a's and