UNICODE and UTF-8

From: "Alain Roger" <raf(dot)news(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: UNICODE and UTF-8
Date: 2006-11-04 15:23:02
Message-ID: 75645bbb0611040723s28172f6at11d660e205ff11dd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I tried to reproduce the same DB on my local server as my web provider gave
me access.

On this DB (from provider) i can see via phpAdmin pages that encoding is
setup to UNICODE.
after reading some documentation, i've seen that i had to create my DB on my
local server like that :

create database mydatabase with encoding='UNICODE';

however, when i do this, my encoding is in UTF-8 via phpAdmin.
UTF8 is a part of UNICODE, but as i'm not sure on how many bits is UNICODE,
how can i setup my local DB to UNICODE value as my provider has ?

thanks a lot,

Al.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message novnov 2006-11-04 15:47:04 Re: Simple stored procedure examples?
Previous Message Stephan Szabo 2006-11-04 12:14:40 Re: Simple stored procedure examples?