ERROR: collation "latin1_general_ci" for encoding "UTF8" does not exist

I have started writting query since a day on postGreS my query is :

CREATE TABLE IF NOT EXISTS utilisateurs (
SEQU_NK SERIAL PRIMARY KEY NOT NULL UNIQUE,
UTILISATEUR_NK bigint NOT NULL,
NOM varchar(25) COLLATE latin1_general_ci NOT NULL DEFAULT '',
PASSE varchar(40) COLLATE latin1_general_ci NOT NULL ,
RACCOURCI varchar(5) COLLATE latin1_general_ci NOT NULL,
DROITS varchar(4) COLLATE latin1_general_ci NOT NULL DEFAULT '....' ,

CONSTRAINT UTILISATEUR_NK UNIQUE (UTILISATEUR_NK,NOM)
) ;
COMMENT ON COLUMN utilisateurs.PASSE IS 'md5';
COMMENT ON COLUMN utilisateurs.DROITS IS 'ceps';

And the error is :

ERROR: collation "latin1_general_ci" for encoding "UTF8" does not exist
LINE 4: NOM varchar(25) COLLATE latin1_general_ci NOT NULL DEFAULT...
^
********** Error **********

ERROR: collation "latin1_general_ci" for encoding "UTF8" does not exist
SQL state: 42704
Character: 143

Could some one please help me ?

--
View this message in context: http://postgresql.nabble.com/ERROR-collation-latin1-general-ci-for-encoding-UTF8-does-not-exist-tp5863581.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.