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.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
