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

On 08/27/2015 06:47 AM, ss wrote:
> 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 ?

From what I can find latin1_general_ci is a MySQL collation:

https://dev.mysql.com/doc/refman/5.1/en/charset-mysql.html

so on that alone I would not expect it to work.

What sort of collation are you trying to achieve?

>
>
>
> --
> 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.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com