Re: Hostnames, IDNs, Punycode and Unicode Case Folding

From: Jonathan Vanasco <postgres(at)2xlp(dot)com>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Hostnames, IDNs, Punycode and Unicode Case Folding
Date: 2015-01-05 20:46:45
Message-ID: C29358AE-0AD3-4EFA-876E-79365F1A5BC3@2xlp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Dec 29, 2014, at 5:36 PM, Mike Cardwell wrote:

> So the system I've settled with is storing both the originally supplied
> representation, *and* the lower cased punycode encoded version in a separate
> column for indexing/search. This seems really hackish to me though.

I actually do the same exact thing and don't think it's hackish. I actually really like being able to see the punycode next to the human representation on simple db pulls. It's barely more disk space and really useful.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raymond Cote 2015-01-05 22:46:28 Re: postgresql versus riak for a global exchange
Previous Message Andy Colson 2015-01-05 20:34:38 Re: postgresql versus riak for a global exchange