Re: UNICODE and UTF-8 - Mailing list pgsql-general

From AgentM
Subject Re: UNICODE and UTF-8
Date
Msg-id 3F85B86D-B5D1-41E0-98F3-EB549F5DDCB9@themactionfaction.com
Whole thread Raw
In response to Re: UNICODE and UTF-8  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Tomi NA"
Date:
Subject: Re: Issue when inserting Slovak characters in database via PHP code
Next
From: Bob Pawley
Date:
Subject: Geometric Datatypes