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?
Thanks,