CODEWITHSUNDEEP
postgresqlms-accessfiltercase-insensitiveaccent-insensitive
Christos Arapidis
Christos Arapidis

Reputation: 15

MS Access + Postgres Accent / Case insensitive editable filter

I want to filter a form using accent and case insensitive filters.

MS Access doesn't support either, but Posgres does. Using these for reference: Does PostgreSQL support "accent insensitive" collations? PostgreSQL: How to make "case-insensitive" query

I asked how to send Postgres specific SQL from within access and the solution is to use a passthrough query Postgresql syntax in ms access

And I get the results I want, regardless of accent or case. HOWEVER, the form's recordset is no longer editable. From my research (for example: How to make a passthrough / passthru query editable? ) Pass through queries are not editable/updateable

Is there a way to filter a form with accent/case insensitive filters and have the resulting recordset updateable?

Upvotes: 0

Views: 85

Answers (1)

Andre
Andre

Reputation: 27644

You can use an Access query (not Pass-Through), using the StrComp Function with vbBinaryCompare = 0.

SELECT foo
FROM bar
WHERE StrComp(foo, "Aáà", 0) = 0

Result 0 = Exact match.

Upvotes: 0

Related Questions