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/
Show quoted text
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.
Show quoted text
On 11/4/06, Martijn van Oosterhout <kleptog@svana.org> 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 isUNICODE,
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.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)iD8DBQFFTMEVIB7bNG8LQkwRAhH4AJ9PlOoZeP7zQ1VG6/6bT1aqcUTz9gCeKM5U
poP157BzFSv0LUGu8fU1iUc=
=PJtK
-----END PGP SIGNATURE-----
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