Re: Surrogate pairs in UTF-8

On Fri, Jan 16, 2015 at 08:16:47AM -0600, Dave Rosckes wrote:
> I have written a test program using postgres that creates a string with a
> surrogate pair. I then insert that string into a varchar property in a
> table.
>
> I then execute a select statement to pull the string out. But when I
> evaluate the string the lead char of the pair is correct, but the following
> pair value is mangled. I run this exact same code using DB2 and it works
> just fine.
>
> Is this a postgres limitation, or is there a specific way surrogate pairs
> need to be handled?

Sounds odd. Can you provide actual queries showing the problem (and
server version).

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> He who writes carelessly confesses thereby at the very outset that he does
> not attach much importance to his own thoughts.
-- Arthur Schopenhauer