Tuesday, June 3, 2008

What is the difference between VARCHAR and VARCHAR2?


Question: What is the difference between VARCHAR and VARCHAR2?


Answer: Well... no difference as of now. Both the VARCHAR and the VARCHAR2 work exactly the same way (both are currently used for storing variable length character strings), but we should avoid using VARCHAR as it's a reserved keyword for future use and hence it may have a different meaning sometime down the line. And at that point the queries involving VARCHAR may required to be changed.



Share/Save/Bookmark


No comments: