RE: Revisited: Oracle and the empty string

2010-10-04 Thread Greg Monroe
u.net] > Sent: Friday, October 01, 2010 4:29 PM > To: Apache Torque Users List > Subject: Re: Revisited: Oracle and the empty string > > Thomas Vandahl wrote: > > On 01.10.10 21:47, Thomas Fischer wrote: > > > In my experience, it is no problem if you keep that fact in m

Re: Revisited: Oracle and the empty string

2010-10-01 Thread Thomas Fischer
Thomas Vandahl wrote: > On 01.10.10 21:47, Thomas Fischer wrote: > > In my experience, it is no problem if you keep that fact in mind. It just > > makes the code non-portable to another database (you only query for not > > null and know it's also not empty in oracle, but not dor other databases).

Re: Revisited: Oracle and the empty string

2010-10-01 Thread Thomas Vandahl
On 01.10.10 21:47, Thomas Fischer wrote: > In my experience, it is no problem if you keep that fact in mind. It just > makes the code non-portable to another database (you only query for not > null and know it's also not empty in oracle, but not dor other databases). > Is it a problem for yaou if "

RE: Revisited: Oracle and the empty string

2010-10-01 Thread Thomas Fischer
> just a question about a "best-practice". We are trying to implement an > XML-to-DB-mapper service on Oracle. The (existing) XSD defines some > fields which distinguish between "not set" (null) and "empty" (""). How > do others handle this in Oracle? Especially within Torque? In my experience, it