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

[ss <shekhar.paris@xxxxxxxxx>]

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.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general