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,