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

Popular posts from this blog

storing byte array as column value in datatable using c#

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

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