Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #63635

Re: unicode troubles and postgres [SOLVED]

Show all headers | View raw

On Fri, Jan 10, 2014 at 6:51 AM, Ethan Furman <ethan@stoneleaf.us> wrote:
> The problem was I had created the database from template0 instead of
> template1, and 0 is SQL-ASCII while 1 is UTF8.

Ah, this is one of the traps with Postgres. This is one of the reasons
I prefer not to touch template[01] and to script the initialization of
a new database - any config changes are committed to source control as
part of that script.

ChrisA

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: unicode troubles and postgres [SOLVED] Chris Angelico <rosuav@gmail.com> - 2014-01-10 07:56 +1100

csiph-web