Avatar of alpha-lemming
alpha-lemming
 asked on

Posgresql: UTF-8/UNICODE DB

Hello,

I'm trying to create  a postgres database on a FreeBSD 6.2 machine like this:
createdb  -E utf-8 -U pguser -p 5432 -h localhost mydb

Open in new window


When I list the databses with "psql -l", I see:
       List of databases
    Name    | Owner | Encoding  
------------+-------+-----------
 mydb    | pguser  | UNICODE

Open in new window


Why "UNICODE" and not UTF-8?

Thanks!
Unix OSDatabasesPostgreSQLFreeBSD

Avatar of undefined
Last Comment
MrNed

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
MrNed

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23