On Sun, Nov 07, 2004 at 12:38:06PM -0600, Michael Sims wrote:
> Sean Chittenden wrote:
> > A boolean value is returned as the strings 't' and 'f', not the
> > constants true and false. This presents all kinds of interesting
> > oddities for code that does something like:
I suspect that behavior has nothing to do with PHP and everything to
do with PostgreSQL. Each DBMS outputs their information in their own
way.
Now, should PHP implement a new standard to convert that into a
standard format, well that's another question. The answer is "no."
That would cause compatibility problems.
Stuff like this will likely be handled by the experimental PDO
extension. When it becomes stable and fully develloped, things will
be very nice.
> You're probably already aware of this, but you can use a bit(1)
> field as a boolean
Most DBMS's don't support BIT column types. Second, some of those
that do don't allow NULL in them. NULL is a legit value for a BOOLEAN
column.
I'll be talking about compatibility issues like this at the
International PHP Conference this coming Wednesday at 13:30 during my
talk entitled "Building Truly Portable Database Applications in PHP."
I'll have the slides up later this week.
--Dan
--
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
data intensive web and database programming
http://www.AnalysisAndSolutions.com/
4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409
--
PHP Internals - PHP Runtime Development Mailing List
To unsubscribe, visit: http://www.php.net/unsub.php
