Prev: Character Encoding for em-dash
Next: newbie sequel question: how do we search for multiple things on 1 field like:
From: Rick Dwyer on 18 Jun 2010 17:37 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. I've always used Navicat and never had a need for the terminal.... until now.
From: "Daniel P. Brown" on 18 Jun 2010 17:45 On Fri, Jun 18, 2010 at 17:37, Rick Dwyer <rpdwyer(a)earthlink.net> 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 the name since it's been a while since I've played with a web Mac personally. I can ask someone here if you can't figure it out. -- </Daniel P. Brown> URGENT: THROUGH FRIDAY, 18 JUNE ONLY: $100 OFF YOUR FIRST MONTH, FREE CPANEL FOR LIFE ON ANY NEW DEDICATED SERVER. NO LIMIT! daniel.brown(a)parasane.net || danbrown(a)php.net http://www.parasane.net/ || http://www.pilotpig.net/ We now offer SAME-DAY SETUP on a new line of servers!
From: Rick Dwyer on 18 Jun 2010 17:45
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 <rpdwyer(a)earthlink.net> > 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 be to copy the table, convert the encoding, > and test it. However, my example database with LATIN1 collation still > worked as expected here. So that may not be the issue for you after > all. > > 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? > > -- > </Daniel P. Brown> > URGENT: > THROUGH FRIDAY, 18 JUNE ONLY: $100 OFF > YOUR FIRST MONTH, FREE CPANEL FOR LIFE > ON ANY NEW DEDICATED SERVER. NO LIMIT! > daniel.brown(a)parasane.net || danbrown(a)php.net > http://www.parasane.net/ || http://www.pilotpig.net/ > We now offer SAME-DAY SETUP on a new line of servers! > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > |