Re: [PHP] Replacing Registered Symbol

2010-06-18 Thread Rick Dwyer
OK, it's definitely an encoding issue... when I change the encoding of my PHP page in BBedit to Western ISO Latin 1, it replaces successfully. --Rick On Jun 18, 2010, at 5:13 PM, Daniel Brown wrote: On Fri, Jun 18, 2010 at 17:07, Rick Dwyer wrote: Navicat shows it as Latin1. I belie

Re: [PHP] Replacing Registered Symbol

2010-06-18 Thread Daniel P. Brown
On Fri, Jun 18, 2010 at 17:37, Rick Dwyer wrote: > > No, I'm on Mac OS 10.5 and apparently I don't have a MySQL client installed > in terminal.  I've always used Navicat and never had a need for the > terminal until now. Should be able to install mysql-client from ports. Not positive on

Re: [PHP] Replacing Registered Symbol

2010-06-18 Thread Rick Dwyer
On Jun 18, 2010, at 5:13 PM, Daniel Brown wrote: Can you hit the database from the command line to see if there's a difference in the output when you take the server and browser out of the equation? No, I'm on Mac OS 10.5 and apparently I don't have a MySQL client installed in terminal

Re: [PHP] Replacing Registered Symbol

2010-06-18 Thread Daniel Brown
On Fri, Jun 18, 2010 at 17:07, Rick Dwyer wrote: > > Navicat shows it as Latin1.  I believe UTF-8 is what it should be, but I > don't want to change it without understanding what impact it will have. Depending on your content, it could be an issue, but probably not. A good way to check would

Re: [PHP] Replacing Registered Symbol

2010-06-18 Thread Rick Dwyer
On Jun 18, 2010, at 4:52 PM, Daniel Brown wrote: Check your database's character encoding. My check: Navicat shows it as Latin1. I believe UTF-8 is what it should be, but I don't want to change it without understanding what impact it will have. Note that, while it won't make a

Re: [PHP] Replacing Registered Symbol

2010-06-18 Thread Daniel Brown
On Fri, Jun 18, 2010 at 16:32, Rick Dwyer wrote: > Hello List. > > I'm trying to replace the registered (®) symbol from a variable via PHP. > > The variable $mystring is set to a MySQL field that contains the value "This > Is The Registered Symbol ®". > > Using the following, I try to replace the

RE: [PHP] Replacing Registered Symbol

2010-06-18 Thread Bob McConnell
From: Rick Dwyer > I'm trying to replace the registered ((r)) symbol from a variable via PHP. > > The variable $mystring is set to a MySQL field that contains the value > "This Is The Registered Symbol (r)". > > Using the following, I try to replace the symbol, but it persists: > > $moditem =