David E. Wheeler

For some reason SQL*Plus is returning non-UTF-8 bytes. I do not understand why and don't have the resources to investigate. Maybe it's worth asking on Stack Overflow or an Oracle...

Is the deploy script you wrote UTF-8 encoded?

> As I would always have to reindex all indexes in a database with reindexdb, I don't see any advantage. That's what I was wondering about. > In addition outside...

The more I think about it, the more convinced I am that this isn't the right thing to do. We shouldn't be making collation decisions for the people using the...

> Is there any reason to use locales? The thing is, we don't. We just default to whatever the DBA has configured things for. It might be more surprising to...

Yeah, that's the thing, I think we have no business choosing a collation.

I'm beginning to come back around to @datafoo's point of view, because using C/POSIX collation has no effect on the data you can store: it's all UTF-8. What it affects...

Yeah, probably a good idea, although even the C and POSIX collations can change when you upgrade glibc. There was a ton of discussion of the issue at PGCon this...

Oh, perhaps you're right, I forgot about that. The examples from the presentation use `en-US.UTF-8`.

Yeah, optionally requiring verify scripts makes a _ton_ of sense.