Need to set the locale.

[docbill]

I just learned the hardware, if you use this Dockerfile postgres will use the POSIX locale. That means all special characters will be mangled... I have added the line:

ENV LANG en_US.UTF-8

into my Dockerfile, but it will take a while to test if that really fixes the problem with non-English characters, long dashes, etc, as it take about 24 hours for my process to build a working database.

[scollier]

@docbill Thanks for bringing it to my attention. I wasn't aware of that. Please do test and let's get that included if it indeed fixes the issue.

[docbill]

Yes. It turns out this is really needed for all docker images. At first I tried just the postgresql docker image, but I found my processes connecting to the database from other containers would not use the same character encoding and have problems. Now all my docker images and all UTF8 characters are properly preserved.

I'm just trying to figure out how to do a fork, as I've done other changes you might want to merge.

[sourcejedi]

This should be fixed by now, right? I think the Fedora base image uses en_US.UTF-8.

https://git.fedorahosted.org/cgit/spin-kickstarts.git/tree/fedora-docker-base.ks?h=0.23.6&id=d0b28ea2c374542fdb5257b007c46a0e930dd8b5

[sourcejedi]

Sorry, I guess that's irrelevant for an app container, because there's no boot process (systemd etc) to set LANG from /etc/locale.conf.

[mattdm]

Note that eventually we want to use C.UTF8 — see https://lists.stg.fedoraproject.org/archives/list/[email protected]/thread/44YDNSOM4KXUY63F336ZUD75XMR5HNHV/