ERROR: collation "latin1_general_ci" for encoding "UTF8" does not exist - Mailing list pgsql-general

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.