On 18/08/2023 12:34 pm, Vitor Freitas wrote:
Hi Mike,
On Tue, Aug 15, 2023 at 4:30 AM Mike Dewhirst
wrote:
Found a great article by Adam Johnson written in February ...
https://adamj.eu/tech/2023/02/23/migrate-django-postgresql-ci-fields-case-insensitive-collation/
This is a grea
Hi Mike,
On Tue, Aug 15, 2023 at 4:30 AM Mike Dewhirst wrote:
> Found a great article by Adam Johnson written in February ...
>
>
> https://adamj.eu/tech/2023/02/23/migrate-django-postgresql-ci-fields-case-insensitive-collation/
>
This is a great reference. It helped me out with the migration f
Found a great article by Adam Johnson written in February ...
https://adamj.eu/tech/2023/02/23/migrate-django-postgresql-ci-fields-case-insensitive-collation/
Covers all the bases.
Thank you Adam
Cheers
Mike
On 7/08/2023 12:28 pm, Mike Dewhirst wrote:
On 6/08/2023 9:17 pm, Chetan Ganji wrot
My tests stopped working so I have decided to abandon case-insensitive
fields and do it all manually.
Thanks everyone.
Cheers
Mike
On Monday, August 7, 2023 at 12:29:28 PM UTC+10 Mike Dewhirst wrote:
> On 6/08/2023 9:17 pm, Chetan Ganji wrote:
>
> Thanks Chetan
>
> I have seen that 'icu' an
On 6/08/2023 9:17 pm, Chetan Ganji wrote:
Thanks Chetan
I have seen that 'icu' and 'und-whatever...' in various places on the
web - so it seems to be spreading - but I haven't had the brainspace to
understand it yet.
I'll try an experiment with provider='C' and locale='C' because that is
ho
Any help visit www.bansloi.com this is django website
On Sun, 6 Aug 2023, 4:48 pm Chetan Ganji, wrote:
> Check this out.
> https://gist.github.com/hleroy/2f3c6b00f284180da10ed9d20bf9240a
>
> # According to Django documentation, it’s preferable to use
> non-deterministic collations
> # instead of
Check this out.
https://gist.github.com/hleroy/2f3c6b00f284180da10ed9d20bf9240a
# According to Django documentation, it’s preferable to use
non-deterministic collations
# instead of the citext extension for Postgres > 12.
# Example migation to create the case insensitive collation
class Migration
On 5/08/2023 7:58 pm, Chetan Ganji wrote:
Hi Mike
RE: The primary use case is to establish case-insensitivity when
checking names - including usernames, company names and
abbreviations/acronyms.
I dont know anything about db_collation.
Me neither
Below 4 lookups should solve most common
8 matches
Mail list logo
