unique constraint is case in-sensitive

CREATE TABLE category
(
catdb_id bigserial NOT NULL,
catdb_name character varying,
catdb_remarks character varying,
CONSTRAINT catdb_id_pk PRIMARY KEY (catdb_id)
)

INSERT INTO category(catdb_name) VALUES('DyCharleS')
---successfully inserted
INSERT INTO category(catdb_name) VALUES('dycharles')
---successfully inserted

Comments

Post a Comment

Popular posts from this blog

storing byte array as column value in datatable using c#

This post covers following objective 1. How to declare and define datatable 2. Add columns at runtime 3. Add column to store byte array (image/file etc) //YOUR PHOTOGRAPH HERE MemoryStream ms = new MemoryStream(); argPhotograph.Save(ms, System.Drawing.Imaging.ImageFormat.Gif); //DECLARING DATATABLE DataTable dt = new DataTable ();   dt . Columns . Add ( "ID" ); dt . Columns . Add ( "Name" ); dt . Columns . Add ( "CreatedOn" , typeof ( DateTime )); dt . Columns . Add ( "Photograph" , typeof ( byte []));   //METHOD 1: ADDING DATA DataRow row = null; row = dt.NewRow(); row[ "ID"] = 1; row[ "Name"] = "Usman"; row[ "CreatedOn"] = DateTime.Now; row[ "Photograph"] = argPhotograph.ToArray(); dt.Rows.Add(row);  //METHOD 2: ADDING DATA dt.Row.Add( 1, "Usman", DateTime.Now, argPhotograph.ToArray());
Read more

post form data and bind with model : using jquery ajax in mvc

There are multiple ways of posting data from view to controller using jquery + ajax in mvc 1. post data by assigning parameters one by one and bind it with model manually 2. post data by serializing form and automatically binding with model 3. post data by assigning parameters one by one + making custom class and assigning data to its variables which are named similarly as that of model Method 1:     $.ajax({         url: "/Controller/SubmitAction",         type: "POST",         dataType: "text",         data: { name: _name, age: _age, id: _id },         success: function (response) {             alert("Success");         },         error: function () {             alert("Error");         }     }); public JsonResult SubmitAction(string name, string age, int id) {       try       {             Person obj = context.Person.FirstOrDefault(x=>x.id = id);             obj.Name = name;             obj.Age = age;
Read more

Htc sensation XL mobile not working with windows 7 or above, along with Htc sync software

Problem: Htc sensation XL connectivity issue with windows 7 or above + Htc sensation XL device detection issue with Android Studio + Htc sensation XL connectivity issue with Htc sync software Solution: For all of the above mentioned issues, please see steps below for smooth & successful activity. Please make sure that 1. In Pc, Htc sync software version 3.2.26 or 3.3.63 is installed. 2. Ur device is connected to PC via usb cable. 3. In mobile, change connectivity options from 'charging' to 'htc sync' 4. In Pc, goto device manager and see for hardware changes in order to see whether device is detected by Pc or not yet, If yes you are good to go, if not follow below mentioned steps 5. Run htc sync in compatible mode by going to properties and changing OS to windows vista, then re-run Htc sync software and re-connect from mobile to see if it detects changes or not, if yes we are good to go but if not see below 6. In Pc, install htc usb drivers fro
Read more