Binary Blob truncated to 8000 bytes – SQL Server 2008 / varbinary(max)

by

I too have encountered a similar problem and after much experimentation I noticed that when using Nhibernate to generate my schema to a file the generated column type was always length 8000.

Setting setting CustomSqlType to Varbinary(max) as suggested above made no difference, however, this work around in my FluentMapping seemed to do the trick:

Map(x => x.LogoBytes).CustomType("BinaryBlob").Length(1048576).Nullable();

The length of course is an arbitrary amount but I think it should be set to something less than int.Max. I am new to Nhibernate so I’m still figuring things out but I’d be interested to know if this helps you.

More Related Contents:

  1. How do you map an enum as an int value with fluent NHibernate?
  2. IndexOutOfRangeException Deep in the bowels of NHibernate
  3. Unable to cast object of type NHibernate.Collection.Generic.PersistentGenericBag to List
  4. NHibernate configuration for uni-directional one-to-many relation
  5. Generate XML mappings from fluent Nhibernate
  6. DateTime precision in NHibernate and support for DateTime2 in NHibernate SchemeExport
  7. How do add NOLOCK with nHibernate?
  8. Syntax to define a NHibernate Filter with Fluent Nhibernate?
  9. How to Eager Load Associations without duplication in NHibernate?
  10. Nhibernate: How to represent Many-To-Many relationships with One-to-Many relationships?
  11. What are the First and Second Level caches in (N)Hibernate?
  12. Inverse Attribute in NHibernate
  13. Fighting cartesian product (x-join) when using NHibernate 3.0.0
  14. What’s the difference between session.Merge and session.SaveOrUpdate?
  15. How can I have NHibernate only generate the SQL without executing it?
  16. JSON.NET and nHibernate Lazy Loading of Collections
  17. List vs Set vs Bag in NHibernate
  18. How to tell Fluent NHibernate not to map a class property
  19. When to use inverse=false on NHibernate / Hibernate OneToMany relationships?
  20. nHibernate mapping to custom types
  21. How to create NHibernate HasManyToMany relation
  22. Is this the right way to eager load child collections in NHibernate
  23. How to create OR statements for NHibernate?
  24. How to save a child with assigned id in nhibernate
  25. What is the difference between JoinQueryOver and JoinAlias?
  26. How do I view the SQL that is generated by nHibernate?
  27. Why doesn’t Entity Framework support ODBC?
  28. NHibernate: difference between Interceptor and Listener
  29. What exactly is “persistence ignorance”?
  30. Programming to interfaces while mapping with Fluent NHibernate

Leave a Comment