Solved

Posgresql: UTF-8/UNICODE DB

Posted on 2011-03-07
1
490 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now