Varchar fields can be of any size up to a limit, which varies by databases: an Oracle 9i database has a limit of 4000 bytes, a MySQL database has a limit of 65,535 bytes (for the entire row) and Microsoft SQL Server has a limit of 8000 characters (unless varchar(max) is used, which has a maximum storage capacity of 2 gigabytes).
Answers
Varchar fields can be of any size up to a limit, which varies by databases: an Oracle 9i database has a limit of 4000 bytes, a MySQL database has a limit of 65,535 bytes (for the entire row) and Microsoft SQL Server has a limit of 8000 characters (unless varchar(max) is used, which has a maximum storage capacity of 2 gigabytes).
@pallav
March 04,2016 At 02:47 PM
Solution #1