Dear All, We are using SQLite and we have the table structure as CREATE TABLE Brand(PcNo numeric(4) Not Null,SubPcNo numeric(4) Not Null,BrandNo numeric(9) Not Null,BrandDescription nVARCHAR(254)Not Null,ST numeric(1),TS numeric(14)) where the index is CREATE UNIQUE index BrandKey1 on Brand(PcNo,SubPcNo,BrandNo). When we use this table in the application we are suppose to sort the datas by BrandDescription.So we tried to create a unique index as CREATE UNIQUE INDEX BrandKey2 on Brand(BrandDescription).But we couldn't able to create the unique index.
Is there any restriction in having nVARCHAR as unique index? Kindly help in this regard. Regards, Farzana. -- View this message in context: http://www.nabble.com/nVARCHAR-as-unique-index-tp17206197p17206197.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users