search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
30.13k stars 3.81k forks source link

sql: support for unaccent insensitive and case insensitive string matching #50346

Open awoods187 opened 4 years ago

awoods187 commented 4 years ago

A customer recently requested support for unaccent insensitive and case insensitive string matching. Coming from MySQL, the customer uses a specific collation (example ut8_general_ci) that is case and accent insensitive that is very "user friendly" as the customer never needs to consider how a data has been inserted. Further, the customer doesn't have to use a specific sql syntax for case and caseinsensitive.

cc @jordanlewis

Epic CRDB-8371

Jira issue: CRDB-6314

awoods187 commented 4 years ago

cc @kai-niemi I filed this issue for tracking but i wouldn't expect any near-term movement

github-actions[bot] commented 1 year ago

We have marked this issue as stale because it has been inactive for 18 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to CockroachDB!