Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I am finding some multibyte columns (Unicode, Big5) are being truncated a bit, clipping off the last character. Why?

April 26, 2017Big5 bit character clipping columns multibyte truncated Unicode

0

Posted

I am finding some multibyte columns (Unicode, Big5) are being truncated a bit, clipping off the last character. Why?

1 Answer

0

Posted

This was a bug present until a little after Slony-I version 1.1.0; the way in which columns were being captured by the logtrigger() function could clip off the last byte of a column represented in a multibyte format. Check to see that your version of src/backend/slony1_funcs.c is 1.34 or better; the patch was introduced in CVS version 1.34 of that file.