Elixir Ecto database create failed on SQL_ASCII May 26, 2015 posted in elixir, ecto, migration, sql, error, issue.

I was just about to create my first database with Ecto migrations in Phoenix, so I ran the create command.

mix ecto.create

But I ran into the following PostgreSQL template issue.

** (Mix) The database for Imageyard.Repo couldn't be created, reason given: ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII) HINT: Use the same encoding as in the template database, or use template0 as template.

I remembered having the same problem with my rails application on my dev environment so you just have to do what the error is suggesting.

Specify the template yourself by adding template: "template0" into your dev and test database config files.

# The files are located under config directory at # config/dev.exs # config/test.exs config :appname, Appname.Repo, adapter: Ecto.Adapters.Postgres, username: "developer", password: "password", database: "appname_dev", template: "template0", size: 10

Run the mix ecto.create again and you have your first database created with Ecto – exciting.

Would you like to get top 5 links on Elixir every Monday?

Sign up to Elixir Digest and stay up to date!