Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Varchar size definition

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-12-12 : 09:03:21
Jon writes "This may be very simple, but it has not been able to be answered by anyone at my company...so here's the issue. I have a table containing a varchar field of size 4. I assumed this meant that it will only accept a 4 digit number. However, I have entered a 5 digit number into this field and it was accepted. I have been told that it may have something to do with the database accepting information in the hexadecimal format and, since I am not familiar with that format, I was curious as to whether or not that was the case. At any rate, my question is why does a varchar field of size 4 accept a 5 digit number?"
   

- Advertisement -