Forum OpenACS Q&A: Encoding of package-create.sql files

When installing an application and using postgresql as the db backend, what determines the encoding applied to files sourced with "\i some_file.sql" from the package-create.sql file (or even the package-create.sql itself)? Are they treated as UTF-8, 8859-1, or what? Does OpenACS have anything to do with it or is it completely up to the db?

I have to confirm this, but it seems that some files containing "insert into ..." statements are converted to 8859-1 when they contain only 8859-1 characters, even though they are UTF-8.

This is on a db created with '-E UNICODE'.