Skip to main content

Hey.


I have made a table called tblImage.
ID field as int
image as Image
Name as Varchar

I have then made a SO by the use of DynamicSQLService instance.

When i try to Create a new record from the SmartTester i get following error message:
Message: Incorrect syntax near '<'. The identifier that starts with 'oqyMfFDxokKfzEoFPYTwmTiyX4CZAveYCNXVT46eEHyAjNeAWPKOGHwRcHflZw8DFBCBM2flIMAAGCQgG9AaoMEEz75G25z1xRBF455KNPEsWZYIQRgR2XnAdZCMHZcy' is too long. Maximum length is 128. The identifier that starts with 'GAhE0QHmWABgQ6Y8IQoTKEKVagFOSghATCMoQwToIQ4aEELK8yhDnfIQx2i4QG3uMQBwkDEIhoxDHggQhCXiIkDSOGJUIRiApTIxCpWwolRfGISrchFSmARilvsohgj8' is too long. Maximum length is 128. The identifier that starts with 'AYQB5NMESVqAHKmxDAwN4Am4FYYACqIEBEqjAZBlQBjE8YLcLYAMENvBIMXTzthNwQgl0gAVfvhEMAiDlEWzwhAL84A8RuAAO9MCFKCyABgPwAghsUIMfuGAKQVhoBBa' is too long. Maximum length is 128. The identifier that starts with 'QcaCOEPCvCCL30A2gJMswEeoIEMnDADGHBAAhNArAs8sAIETFMFJUDADoAg1jlHoAhMFYQMFtCDNAwVCznQQQ36qYEKQOEIKpjBBaDwxhWcoQEDIMMTFgCEkQqCATsQR' is too long. Maximum length is 128


Has any one used field type of image in SO?


 

SOLVED!


The field in the database needs to be a nvarchar(max).


 


closed.


Reply