Thread: UNICODE and UTF-8

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.

On Sat, Nov 04, 2006 at 04:23:02PM +0100, Alain Roger wrote:
> 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 ?

As far a postgres is concerned, UTF8 is UNICODE. IIRC some versions
said one name, some the other, but they mean the same thing.

So maybe you have a different version than your provider?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Yes, my provider has v8.0.1 and i have installed v8.1.4.

thanks for your confirmation.

Al.

On Nov 4, 2006, at 11:34 , Martijn van Oosterhout wrote:

> On Sat, Nov 04, 2006 at 04:23:02PM +0100, Alain Roger wrote:
>> 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 ?
>
> As far a postgres is concerned, UTF8 is UNICODE. IIRC some versions
> said one name, some the other, but they mean the same thing.
>
> So maybe you have a different version than your provider?

Somewhere around release 8, the encoding "UTF8" was made to mean what
"UNICODE" meant before. "Unicode" is not an encoding so "UTF-8" is
the proper terminology.

Cheers,
M