Hi, I'm trying to map binary data to the database. I tried using SqlType = "varbinary(MAX)", but that breaks all of my SqlLite testcases (SQLite error near "MAX": syntax error).
So I figured it should be possible to just lookup what numeric value MAX is and assign that explicitly. According to Sql Server 2008 books its 2147483647 ( http://msdn.microsoft.com/en-us/library/ms188362.aspx) and I changed my mapping to look like this: [Property(ColumnType = "BinaryBlob", SqlType = "varbinary(2147483647)")] public byte[] BinaryData { get; set; } Now the whole thing fails during Schema export with the following error: *The size (2147483647) given to the column 'BinaryData' exceeds the maximum allowed for any data type (8000).* Has anyone else encountered this and possibly found a solution to the problem? greetings, Daniel Hölbling http://www.tigraine.at --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
