Re: [PHP] Foreign Characters Break in MySQL

2010-01-22 Thread Ashley Sheridan
On Fri, 2010-01-22 at 12:04 -0500, tedd wrote: > At 4:18 PM + 1/22/10, Ashley Sheridan wrote: > > > >You'd be surprised how many people still use a dumb browser! > > > >Thankfully though, it seems that people are wising up a bit more, as > >these stats from a media website show: > > > >Safari

Re: [PHP] Foreign Characters Break in MySQL

2010-01-22 Thread Jochem Maas
Op 1/22/10 5:18 PM, Ashley Sheridan schreef: ... > > You'd be surprised how many people still use a dumb browser! well, no not really - but then we're in the same business :) I wasn't discounting the use of the encoding META tag, just pointing out that it's a hack we have to use (and that we sh

Re: [PHP] Foreign Characters Break in MySQL

2010-01-22 Thread tedd
At 4:18 PM + 1/22/10, Ashley Sheridan wrote: You'd be surprised how many people still use a dumb browser! Thankfully though, it seems that people are wising up a bit more, as these stats from a media website show: Safari 42624 Firefox 3.5 1320 Firefox 3

Re: [PHP] Foreign Characters Break in MySQL

2010-01-22 Thread Ashley Sheridan
On Fri, 2010-01-22 at 17:15 +0100, Jochem Maas wrote: > Op 1/22/10 9:41 AM, Ashley Sheridan schreef: > > On Fri, 2010-01-22 at 03:47 +0100, Jochem Maas wrote: > > > >> Op 1/22/10 2:28 AM, Ryan Park schreef: > >>> Forgot to reply all. > >>> > >>> You can see that it's in the middle of the sql state

Re: [PHP] Foreign Characters Break in MySQL

2010-01-22 Thread Jochem Maas
Op 1/22/10 9:41 AM, Ashley Sheridan schreef: > On Fri, 2010-01-22 at 03:47 +0100, Jochem Maas wrote: > >> Op 1/22/10 2:28 AM, Ryan Park schreef: >>> Forgot to reply all. >>> >>> You can see that it's in the middle of the sql statement. >>> It looks fine here but some how it breaks during the query

Re: [PHP] Foreign Characters Break in MySQL

2010-01-22 Thread Ryan Park
Thank you all for the helpful comments. I've finally solved the problem through sql command "set name." On 1/22/2010 1:53 AM, Michael A. Peters wrote: Ashley Sheridan wrote: You're also forgetting one of the most important elements of this. If you're displaying the characters on a web page,

Re: [PHP] Foreign Characters Break in MySQL

2010-01-22 Thread Michael A. Peters
Ashley Sheridan wrote: You're also forgetting one of the most important elements of this. If you're displaying the characters on a web page, chances are that you need to add a corresponding meta tag to inform the browser that the content is utf-8 Otherwise the browser will attempt to guess

Re: [PHP] Foreign Characters Break in MySQL

2010-01-22 Thread Ashley Sheridan
On Fri, 2010-01-22 at 03:47 +0100, Jochem Maas wrote: > Op 1/22/10 2:28 AM, Ryan Park schreef: > > Forgot to reply all. > > > > You can see that it's in the middle of the sql statement. > > It looks fine here but some how it breaks during the query. > > > > > mysql_connect("localhost", "adminID

Re: [PHP] Foreign Characters Break in MySQL

2010-01-21 Thread Jochem Maas
Op 1/22/10 2:28 AM, Ryan Park schreef: > Forgot to reply all. > > You can see that it's in the middle of the sql statement. > It looks fine here but some how it breaks during the query. > > mysql_connect("localhost", "adminID", "password") or die(mysql_error()); > echo "Connected to MySQL"; > >

Re: [PHP] Foreign Characters Break in MySQL

2010-01-21 Thread Eric Lee
Hi, all, I'am not able test it out now. Did you tried to change the collation to utf8_bin from utf8_general_ci ? Eric, Regards, On 1/22/10, Ryan Park wrote: > > Forgot to reply all. > > You can see that it's in the middle of the sql statement. > It looks fine here but some how it breaks durin

Re: [PHP] Foreign Characters Break in MySQL

2010-01-21 Thread Ryan Park
Forgot to reply all. You can see that it's in the middle of the sql statement. It looks fine here but some how it breaks during the query. "; mysql_select_db("databasename") or die(mysql_error()); echo "Connected to Database"; $sql = "INSERT INTO xe_modules (module_srl, module, module_category

Re: [PHP] Foreign Characters Break in MySQL

2010-01-21 Thread Jim Lucas
Ryan Park wrote: > Hello I'm currently trying to use PHP to insert foreign characters into one > of the mysql database tables.mysql_query() worked seamlessly, but when I > check the inserted data on phpMyAdmin it shows the foreign characters in > broken letters, like this ì‹œíŒ <- jibberish...Th

[PHP] Foreign Characters Break in MySQL

2010-01-21 Thread Ryan Park
Hello I'm currently trying to use PHP to insert foreign characters into one of the mysql database tables.mysql_query() worked seamlessly, but when I check the inserted data on phpMyAdmin it shows the foreign characters in broken letters, like this ì‹œíŒ <- jibberish...The foreign characters sho