Thanks for the reply Adrian. I have been given mysql schema and i have to create table using postgres..this is the information I have. Could u still help me ? If not then please let me know precisely that what should I ask the task giver in order to make you understand the question? (If I am right then collation is used to sort the data) ..may be he mean sorting the data on alphabetical order or something similar On Aug 27, 2015 11:00 PM, "Adrian Klaver-4 [via PostgreSQL]" < ml-node+s1045698n5863613...@n5.nabble.com> wrote:
> 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 > [hidden email] <http:///user/SendEmail.jtp?type=node&node=5863613&i=0> > > > -- > Sent via pgsql-general mailing list ([hidden email] > <http:///user/SendEmail.jtp?type=node&node=5863613&i=1>) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://postgresql.nabble.com/ERROR-collation-latin1-general-ci-for-encoding-UTF8-does-not-exist-tp5863581p5863613.html > To start a new topic under PostgreSQL - general, email > ml-node+s1045698n1843780...@n5.nabble.com > To unsubscribe from ERROR: collation "latin1_general_ci" for encoding > "UTF8" does not exist, click here > <http://postgresql.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5863581&code=c2hla2hhci5wYXJpc0BnbWFpbC5jb218NTg2MzU4MXwtMTAyNzI5NzU1Mg==> > . > NAML > <http://postgresql.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- View this message in context: http://postgresql.nabble.com/ERROR-collation-latin1-general-ci-for-encoding-UTF8-does-not-exist-tp5863581p5863626.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
