Re: Using MS Access front-end with PG

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org
Subject: Re: Using MS Access front-end with PG
Date: 2007-04-04 04:02:01
Message-ID: 921152.97401.qm@web31805.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 2.) The Like function in SQL Server is case insensitive, PG it is case
> sensitive. The ilike function is not recognised by Access and it tries
> to turn that into a string, making my test (like "ilike 'blah'")
>
> Has anyone had any experience with moving an access program from SQL
> server to PG?
>
> Is there any way to change the text qualifier in PG or the case sensitivity?

I wonder if this would be a good feature to request from the ODBC developers by adding a parameter
to the drivers to use ilike instead of like.

Regards,
Richard Broersma Jr.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2007-04-04 04:28:36 Re: Using MS Access front-end with PG]
Previous Message Tom Lane 2007-04-04 03:50:51 Re: Using MS Access front-end with PG]