Re: [Zope-DB] Null characters & booleans

2005-04-08 Thread Cliff Ford
Watch out if you need to use fields longer than 4000 characters - Oracle CLOBs return handles rather than contents, as in MySQL Text fields for example. So you need extra coding in your presentation later. Also, watch out for Database X returning result.FieldName whilst Database Y returns resul

Re: [Zope-DB] Null characters & booleans

2005-04-08 Thread Charlie Clark
On 2005-04-08 at 10:44:59 [+0200], Andrew Veitch <[EMAIL PROTECTED]> wrote: > We'd be willing to provide patches for both these issues if there's > interest and agreement it's a sensible way to go. The most sensible thing is if the DA does not have to do the quoting at all and that this is eith

[Zope-DB] Null characters & booleans

2005-04-08 Thread Andrew Veitch
We're doing a lot with relational databases and Zope at the moment. We are trying to get our code to work with as many different relational backends as possible with a minimal amount of rewriting. The first issue we've got is chr(0) appearing in input strings. Using Postres/Psycopg if we do: