Error : String or binary data would be truncated.

I am trying to submit some form values to the database

However i am getting an error when i insert something like (E. Jensen) or N/o . or such special characters in text fields like street. The error is

Error Executing Database Query.  
[Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.  
 
The error occurred in E:\docs_secure\icepe\addhvp.cfm: line 9
 
7 : values('#EVALUATE('form.sitename')#','#EVALUATE('form.street')#','#EVALUATE('form.city')#','#EVALUATE('form.region')#'
8 : ,'#EVALUATE('form.county')#','#EVALUATE('form.zip')#','#EVALUATE('form.state')#','#EVALUATE('form.colocator')#',
9 : '#EVALUATE('form.siteowner')#','#EVALUATE('form.hvpowner')#','#EVALUATE('form.hvptype')#','#EVALUATE('form.phone')#','#EVALUATE('form.note')#')
10 : </cfquery>
11 : <cfquery  name="getsid1" datasource="#dbdsn#" username="#dbuser#" password="#dbpw#">
 

--------------------------------------------------------------------------------
 
SQL    insert into site_info (sitename,street,city,region,county,zip,state,colocator_name,sowner_name,owner_hvp,type_of_hvp,phone_no,note) values('McCall','Leonard Avenue, (E. Jensen )','Fresno','' ,'','','CA','Larry Duba', 'PGE','Unknown','None','268-0441','')  
DATASOURCE   sqldatas
VENDORERRORCODE   8152
SQLSTATE   22001
 

What do i need to do here?
Start Free Trial