Christopher Browne cbbrowne
Thu Jun 30 18:08:41 PDT 2005
Ian Burrell wrote:

>I didn't see any response to the bug I found with slon truncating
>strings with UTF-8 characters in them.  The truncated strings were
>being written to the sl_log_1 table.  This was causing the SYNC to
>fail on the slave because of constraints violations.  It was also
>corrupting data.  The slon_quote_literal shortens the copied string by
>one byte for every multi-byte character.
>
>  
>
I'm trying this out; it looks as though it's not causing any regressions
for existing tests, which is a good thing.

I don't get much call to set up queries involving UTF-8; would it be
possible for you to give a brief sample of what is breaking so that we
can set up a test for it?

It would suffice to have a little script that sets up a database (do you
need to specify locale at DB create time? not sure...), creates a table,
and then inserts some (achy-breaky) data into it.

The change LOOKS good; I just want to make sure that we have a proper
test case to verify that it's working properly.

I just don't want make up a useless example that doesn't test it...


More information about the Slony1-general mailing list