VARCHAR: Friend or Foe

You may also like...

1 Response

  1. Bala says:

    Thanks for the great post.

    Changing the datatype from varchar to char for a given column may result in

    a) data mismatch if the same column is being used in local or join predicate.
    b) varchar returns value without padding where as char returns back with padding

    Good developer would handle these two things with trim function. Esp it would be difficult to review the entire code if it is already in production.

Leave a Reply

Your email address will not be published. Required fields are marked *