If I convert both the Date and logical columns to character then everything works fine. Then I changed all the “Date” type fields to “character” type. You can’t post HTML code. You can’t post IFCode. Stack Overflow works best with JavaScript enabled. You can’t edit your own posts.

Uploader: Vunos
Date Added: 23 November 2013
File Size: 27.80 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 76340
Price: Free* [*Free Regsitration Required]

This site uses cookies for analytics, personalized content and ads. How can we make this better?

Error: Invalid character value for cast specification

Please provide as much detail as possible. I know that it’s most likely from trying to assign a string to an integer field. Hope that helps, John This post is provided ‘as is’ and confers no express or implied warranties or rights. I’ll play with it some more and let you know what I find.

Solution or Workaround Change the date value in the source data. You can’t edit HTML code. You can’t post JavaScript. I disagree with the third bullet. It detects that a character is out of the domain for the conversion e.


Sign up using Facebook. Thanks for the posting etiquette, didn’t know. You can’t delete other topics.

Friday, March 19, 2: The error is generated when I try to insert to a table. Attempting to load data containing dates earlier than will return the error above.

You can’t edit your own invaild. It is related to the insertid not being returned. After all, you will be the one supporting it!

Attempt to debug without enclosing the date as if it were character data, which does not produce your stated error. Many other data sources will accept dates that precedeincluding personal geodatabases, Oracle, and shapefiles.

If those values are not integers, that would be the problem. For Anyone stumbling on this 5 years laterin R you can use the varTypes argument in sqlSave like sqlSave Has anyone else encountered this problem? Invalid character value for cast specification.

Invalid character value for cast specification – Microsoft SQL / MS SQL Server

You can’t delete your own posts. There doesn’t seem to be a good fix aside from converting to character. You can’t send emails. Ron Please help us, help you -before posting a question please read Before posting a performance problem please read. I updated again, it worked.


Error: Invalid character value for cast specification

You can’t post IFCode. Please mark the post as answered to help others to choose the best. You can’t post new topics. What issues are you having odbf the site? Is This Content Helpful? Post as a guest Name.