MySql varchar type performance

As I understand if you declare a column as varchar(15) or varchar(200), it makes no difference in memory size. If you store a 4-character string it should only use around 4 bytes. This is the same in Oracle for varchar2. But, for Oracle, their performance are different as the bigger size you set, the more overhead will be used.

Is it the same in MySQL (or any other database)?

Answers


  • VARCHAR:

    1. Stores strings of variable length.
    2. The length parameter specifies the maximum length of the strings
    3. It stores up to 2000 bytes of characters
    4. It will occupy space for NULL values
    5. The total length for strings is defined when database was created.
  • VARCHAR2:

    1. Stores strings of variable length.
    2. The length parameter specifies the maximum length of the strings
    3. It stores up to 4000 bytes of characters
    4. It will not occupy space for NULL values
    5. The total length of strings is defined when strings are given

Need Your Help

How can I set properties of a clone object?

actionscript-3 flash flash-cc

I found a good tutorial about cloning objects on this site (thanks to Andrey Popov). I've modified it, created a mc and a textfield. The problem is I can't set default values for the mc's and the

UpdateListItem method and System Account

sharepoint

I've developed a Help Desk application in Visual Studio that uses a Sharepoint List to store the data.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.