Re: [PHP] Character set problems

2008-04-04 Thread Robert Cummings
On Thu, 2008-04-03 at 21:56 -0700, Rob Gould wrote: I'm having a hard time figuring out why my character sets and data look when when viewed in phpAdmin when browsing the table-columns, but then I go to show the data on my web-page with PHP, I get garbage-characters where I should be

[Fwd: Re: [PHP] Character set problems]

2008-04-04 Thread Ryan Yagatich
Forwarding back to the list, since I'm one of those evil people that uses HTML to write email :) Original Message Robert Cummings wrote: snip So, based on the headers I'm using, and the myphpAdmin settings, is there something I'm missing? I guess I was assuming since the

Re: [PHP] Character set problems

2008-04-04 Thread Rob Gould
mysql_query(SET NAMES utf8); This above line of code fixed my character problems. Yay! Was curious though - - - -is there a place somewhere in the cPanel or myPHPAdmin on my ISP (www.bluehost.com), where I can just have this happen automatically, or do I need to put this in my code

Re: [PHP] Character set problems

2008-04-04 Thread viraj
in most php apps, they use a separate database connection class. just locate the function where it does mysql_select_db(), you can place the line right after it selects the db. this will set name for each connection, so no need to specifically set name every time you execute a query. or if you

[PHP] Character set problems

2008-04-03 Thread Rob Gould
I'm having a hard time figuring out why my character sets and data look when when viewed in phpAdmin when browsing the table-columns, but then I go to show the data on my web-page with PHP, I get garbage-characters where I should be seeing apostrophs and special foreign-characters. I copied