Solved

Posgresql: UTF-8/UNICODE DB

Posted on 2011-03-07
1
492 Views
Last Modified: 2016-02-10
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
Comment
Question by:alpha-lemming
1 Comment
 
LVL 7

Accepted Solution

by:
MrNed earned 500 total points
ID: 35066047
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Insert with SET how to handle join 6 72
Log File Creation with Header and Footer 17 95
Writing a UNIX script menu allowing for multiple options. 5 57
constraint check 2 40
FreeBSD on EC2 FreeBSD (https://www.freebsd.org) is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question