On Mon, Dec 29, 2014 at 11:50:54PM +0000, Mike Cardwell wrote:
>
> CREATE UNIQUE INDEX hostnames_hostname_key ON hostnames (lower(punycode_encode(hostname)));
This wouldn't work to get the original back if oyu have any IDNA2003
data, because puncode-encoding the UTF-8 under IDNA2003 and then
punycode-decoding it doesn't always result in the same label. See my
other message.
Did I mention that IDNA is a mess?
A
--
Andrew Sullivan
ajs@crankycanuck.ca