Re: Hostnames, IDNs, Punycode and Unicode Case Folding - Mailing list pgsql-general

From Jonathan Vanasco
Subject Re: Hostnames, IDNs, Punycode and Unicode Case Folding
Date
Msg-id C29358AE-0AD3-4EFA-876E-79365F1A5BC3@2xlp.com
Whole thread Raw
In response to Hostnames, IDNs, Punycode and Unicode Case Folding  (Mike Cardwell <pgsql@lists.grepular.com>)
List 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
nextto the human representation on simple db pulls.  It's barely more disk space and really useful.   



pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: postgresql versus riak for a global exchange
Next
From: Raymond Cote
Date:
Subject: Re: postgresql versus riak for a global exchange