On Sunday 10 February 2008 1:26 pm, Ed Leafe wrote: > On Feb 10, 2008, at 2:45 PM, Adrian Klaver wrote: > > So the option here is to go the myBizobj.getTempCursor() route. > > It depends: if you want to make the round-trip to the database, use > getTempCursor() and then go with Postgres 'ilike' syntax. Or just use > the local data and use SQLite's 'like' syntax, which is case- > insensitive. > > > -- Ed Leafe >
For now the Sqlite syntax works as the Postgres database has an encoding of SQL_ASCII. When I migrate it to version 8.3 I plan on using UTF8 encoding which will change the Sqlite behavior. Thanks for the information. Is Sqlite a dependency for Dabo or is it embedded in the code? -- Adrian Klaver [EMAIL PROTECTED] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
