I literally searched for how to create a UTF8 database with zero helpful results. It's all just how to convert it. The few helpful results are just how to copy over a template, which just return syntax errors when I attempt them.

@ethot CREATE DATABASE name ENCODING 'UTF8' template=template0 OWNER user;

Follow

@ethot Easier way of dealing with this is to reinstall your OS and before you install Postgres, you change your system locale to UTF8

· · Web · 1 · 0 · 0
@matrix I can just yeet postgresql, can't I? Why reinstall the entire OS?

Also, where/how would I change the system locale?
Sign in to participate in the conversation
Game Liberty Mastodon

Mainly gaming/nerd instance for people who value free speech. Everyone is welcome.