Performance of char vs varchar

  • Hi All!!

    Difference between the char and varchar data type in performance point of view?

    What will the impact on performance (memory or I/O) if I convert char type of column to varchar?

  • I would expect the change in performance to be very little.

    But you may recover more disk space by changing to variable character columns. i.e. the database may have more space availbale to grow after you make the data type change.

    Personally, i do not use char very often, unless the column needs to be only 1 or 2 in lenght. I have even seen columns defined as varchar (1), and that makes no sense at all.

    John

  • It depends on what kind of data you have or getting in for that column.

    See here

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply