Re: [PHP-DB] NULL values

On Fri, Dec 3, 2010 at 6:25 PM, Ron Piggott wrote: > > When I do the following query in mySQL only 1 record is retrieved. > > SELECT * FROM `paypal_payment_info` WHERE `os1` NOT LIKE 'commission_paid' > > I am surprised by this.  This one record has no characters in it, but the > “INSERT INTO” th

[PHP-DB] NULL values

When I do the following query in mySQL only 1 record is retrieved. SELECT * FROM `paypal_payment_info` WHERE `os1` NOT LIKE 'commission_paid' I am surprised by this. This one record has no characters in it, but the “INSERT INTO” that created it used: ( `os1` ) VALUES ( ‘’ ) instead of: ( `o

[PHP-DB] Incorrect encoding when data read from a mysql database

Hi, I am designing a website that requires storing data in 3 different languages, English, Portuguese and Tetum. When I read the data from the database the accented characters are displayed as a ? in Firefox and Opera, a square in IE and correctly in Chrome How can I convert it on the fly and d