On 15 Jul 2013, at 5:35am, techi eth <[email protected]> wrote: > I found so many Type name to be used while creating table for array > type.What is significance of size under bracket ?.What is differences among > all ? > http://www.sqlite.org/datatype3.html > ----------------------- > CHARACTER(20) > VARCHAR(255) > VARYING CHARACTER(255) > NCHAR(55) > NATIVE CHARACTER(70) > NVARCHAR(100) > TEXT > -----------------------
In SQLite, the the numbers in brackets are ignored. All values are stored just as they are when you supply them. In some versions of SQL, the numbers are the maximum length. For example NCHAR(55) means that if you supply 30 characters, SQL stores 30 characters, but if you supply 80 characters, SQL cuts the end off and stores only the first 55. In other versions of SQL, the numbers are the length. For example NCHAR(55) means that if you supply 30 characters, SQL adds blanks on the end and stores 55 characters, but if you supply 60 characters, SQL cuts the end off and tores only the first 55. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
