<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I'm trying to create &nbsp;a postgres database on a FreeBSD 6.2 machine like this:<br />

<pre><code class="code-1 nolinks" id="code-10-26870243-1"><span>createdb  -E utf-8 -U pguser -p 5432 -h localhost mydb</span>
</code></pre>
<br />
When I list the databses with &quot;psql -l&quot;, I see:<br />

<pre><code class="code-1 nolinks" id="code-10-26870243-2"><span>       List of databases</span>
<span>    Name    | Owner | Encoding  </span>
<span>------------+-------+-----------</span>
<span> mydb    | pguser  | UNICODE</span>
</code></pre>
<br />
Why &quot;UNICODE&quot; and not UTF-8?<br />
<br />
Thanks!
</div>
</div>


Hello,

I'm trying to create  a postgres database on a FreeBSD 6.2 machine like this:
(CODE)

When I list the databses with "psql -l", I see:
(CODE)

Why "UNICODE" and not UTF-8?

Thanks!

Posgresql: UTF-8/UNICODE DB

Unix is a multitasking, multi-user computer operating system originally developed in 1969 at Bell Labs. Today, it is a modern OS with many commercial flavors and licensees, including FreeBSD, Hewlett-Packard’s UX, IBM AIX and Apple Mac OS-X. Apart from its command-line interface, most UNIX variations support the standardized X Window System for GUIs, with the exception of the Mac OS, which uses a proprietary system.

Unix OS

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.

PostgreSQL

FreeBSD is a free Unix-like operating system that is a direct descendant of BSD. FreeBSD contains a significant collection of server-related software in the base system and the ports collection, it is possible to configure and use FreeBSD as a mail server, web server, Firewall, FTP server, DNS server and a router, among other applications. Although FreeBSD does not install the X Window System by default, it is available in the FreeBSD ports collection. A number of Desktop environments such as GNOME, KDE and Xfce, and lightweight window managers such as Openbox, Fluxbox and dwm are also available to FreeBSD.