Re: another seemingly simple encoding question - Mailing list pgsql-general

From John D. Burger
Subject Re: another seemingly simple encoding question
Date
Msg-id 8c7b7e16a736c419961bd75a75c04374@mitre.org
Whole thread Raw
In response to another seemingly simple encoding question  (joseph <kmh496@kornet.net>)
List pgsql-general
> i have a problem matching a utf8 string with a field in a database
> encoded in utf8.

You seem to give all the details of your configuration, but unless I
misread your message, you don't say what the actual problem is.  Can
you provide more details?  What exactly doesn't work?

This may not be the issue, but many people don't realize that there are
sometimes multiple ways to encode what is conceptually the same string
in UTF8 (or any of the Unicode encodings).  If you do not canonicalize
your strings using one of the Unicode normalization forms, then
seemingly identical strings may not match, because they are not
byte-for-byte identical.

- John D. Burger
   MITRE


pgsql-general by date:

Previous
From: "Reimer"
Date:
Subject: Re: URGENT! could not access status of transaction
Next
From: "Jim C. Nasby"
Date:
Subject: Re: URGENT! could not access status of transaction