"ldh@xxxxxxxxxxxxxxxxxx" <ldh@xxxxxxxxxxxxxxxxxx> writes: > Is it possible that the client I am using or the way I am creating the test database might affect this scenario? I use DBeaver and use the default settings to create the database: > - default encoding: UTF8 > - collate: English_United States.1252 > - ctype: English_United States.1252 Yeah, I was thinking of quizzing you about that. I wonder whether something is thinking it needs to transcode to WIN1252 encoding and then back to UTF8, based on the .1252 property of the LC_XXX settings. That shouldn't account for any 500X factor either, but we're kind of grasping at straws here. Does Windows have any locale choices that imply UTF8 encoding exactly, and if so, do your results change when using that? Alternatively, try creating a database with WIN1252 encoding and those locale settings. regards, tom lane
