I was under impression that declaration of char(4) can store only values of exact length of 4 characters. However I was able to insert empty string and strings of less characters than 4.
Is there some datatype that will only accept string of declared length? Strings with less characters should be refused. Or I'm left only with application logic to check desired string length?
peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster
karthik291086 0 Newbie Poster
I think u have to apply some simple logic ... there is no specific keyword to accept exact string length...
dickersonka 104 Veteran Poster
it will allow up to 4
i would either go with some client side code, or used a stored procedure that will check the length before inserting and reject the data
this does sound more like a business rule, so i would say keep it in the business logic portion of the app
peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster
Thanx for confirming that for me
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.