Local environment uses en_US.UTF-8 locale, cloud uses C.UTF-8

Bug report

Describe the bug

The local environment created by supabase start creates a database with a locale of en_US.UTF-8 whereas the Supabase cloud database is created with a locale of C.UTF-8.

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

1. Run supabase start
2. Dump local database.
3. Create a Supabase cloud project.
4. Dump cloud database.
5. Compare the difference.

Expected behavior

I would expect them to be the same because a different locale means that Postgres sorting, string functions, pattern matching and other aspects of the database can differ in varying degrees.

References: https://www.postgresql.org/docs/current/locale.html#id-1.6.11.3.5

Screenshots

None.

System information

• OS: Linux
• Browser: none
• Version of supabase-cli: 1.35.0
• Version of Node.js: 16.18.0

Additional context

I am betting this is caused by the locale of my desktop Linux system being set to en_US.UTF-8. However, I don't think that changing my system's locale should be the solution.

One thing I tried that didn't work: LANG=C.UTF-8 LC_ALL=C.UTF-8 LANGUAGE=C.UTF-8 npx supabase start

I was going to try and just use the cloud database for our developers, but I see that there is no way to run supabase db reset against the remote cloud db...

[github-actions]

🎉 This issue has been resolved in version 1.36.3 🎉

The release is available on:

• npm package (@latest dist-tag)
• GitHub release

Your semantic-release bot 📦🚀