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

Groups > comp.lang.python > #63635 > unrolled thread

Re: unicode troubles and postgres [SOLVED]

Back to article view | Back to comp.lang.python

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

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

#63635 — Re: unicode troubles and postgres [SOLVED]

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

[toc] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web