On 2020/12/03 1:04, Heikki Linnakangas wrote:
Hi, PostgreSQL allows writing custom encoding conversion functions between any character encodings, using the CREATE CONVERSION command. It's pretty flexible, you can define default and non-default conversions, and the conversions live in schemas so you can have multiple conversions installed in a system and you can switch between them by changing search_path. However: We never use non-default conversions for anything. All code that performs encoding conversions only cares about the default ones.
Yes. I had to update pg_conversion.condefault directly so that we can use custom encoding when I registered it. The direct update of pg_conversion is of course not good thing. So I was wondering if we should have something like ALTER CONVERSION SET DEFAULT. Regards, -- Fujii Masao Advanced Computing Technology Center Research and Development Headquarters NTT DATA CORPORATION