[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 524
  • Last Modified:

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!
0
alpha-lemming
Asked:
alpha-lemming
1 Solution
 
MrNedCommented:
It's actually the same thing (UTF-8 is 8-bit Unicode). Haven't personally seen it do that, but never tried it on FreeBSD.

http://www.postgresql.org/docs/8.3/static/multibyte.html#MULTIBYTE-CHARSET-SUPPORTED
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now