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 hav

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

[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: >> 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 hea

Re: [PHP] Character set problems

2008-04-03 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 se

[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 all