could not interpret type: AnsiStringFixedLength

nathanbaulch · **Joined:** Wed Aug 31, 2005 9:29 pm **Posts:** 14

I need SchemaExport to create a column of type CHAR(12). It looks like AnsiStringFixedLength is what I need, but I get the following error:

Additional information: could not interpret type: AnsiStringFixedLength

Shouldn't this map directly to NHibernate.SqlTypes.AnsiStringFixedLengthSqlType?

I have searched nhibernate.org, hibernate.org and this forum for "AnsiStringFixedLength" with no luck.

KPixel · **Posted:** Fri Sep 02, 2005 7:00 am

I don't have any experience on that; did you try to set the length attribute in your mapping ?

nathanbaulch · **Joined:** Wed Aug 31, 2005 9:29 pm **Posts:** 14

Yes, but that produces VARCHAR(12), not CHAR(12).

KPixel · **Posted:** Tue Sep 06, 2005 8:22 am

It looks like using VARCHAR is a design choice... And I don't know how to change that.

paulh · **Posted:** Tue Sep 06, 2005 1:26 pm

I suggest that you raise it as a bug on Jira

k-dub · **Joined:** Thu May 12, 2005 8:45 am **Posts:** 226

What does your mapping look like? I would guess that

Code:

type="Char" length="12"

should work, but I'm not able to check it right now.

fsimard · **Joined:** Wed Dec 22, 2004 12:04 pm **Posts:** 7

I have the same problem

i try the solution to specified the lengh of the Char

Code:

But i receive a n exception when i try to insert

Code:

at NHibernate.Type.CharType.Set(IDbCommand cmd, Object value, Int32 index)
   at NHibernate.Type.NullableType.NullSafeSet(IDbCommand cmd, Object value, Int32 index)
   at NHibernate.Type.NullableType.NullSafeSet(IDbCommand st, Object value, Int32 index, ISessionImplementor session)
   at NHibernate.Persister.EntityPersister.Dehydrate(Object id, Object[] fields, Boolean[] includeProperty, IDbCommand st, ISessionImplementor session)
   at NHibernate.Persister.EntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, SqlString sql, Object obj, ISessionImplementor session)

fsimard · **Joined:** Wed Dec 22, 2004 12:04 pm **Posts:** 7

I have implement a IUserType to provide solution for mapping for char with length more than one

If you find an improvement or Bug in this code. Please send me and email

Code:

/// <summary>
   /// Summary description for MultipleCharType.
   /// </summary>
   public class MultipleCharType:NHibernate.IUserType
   {
      private static readonly bool IsDebugEnabled;
      private static NullableType multipleChar = NHibernate.NHibernateUtil.String;

      static MultipleCharType()
      {
         //cache this, because it was a significant performance cost
         IsDebugEnabled = LogManager.GetLogger( typeof( IType ).Namespace ).IsDebugEnabled;
      }

      private ILog Log
      {
         get { return LogManager.GetLogger( GetType() ); }
      }

      public MultipleCharType()
      {
      }

      #region IUserType Members

      public new bool Equals(object x, object y)
      {
         if(x==y) return true;

         string lhs = (x==null) ? null : (string)x;
         string rhs = (y==null) ? null : (string)y;

         return multipleChar.Equals(lhs, rhs);
      }

      public NHibernate.SqlTypes.SqlType[] SqlTypes
      {
         get
         {
            return new SqlType[] { multipleChar.SqlType };
         }
      }

      public object DeepCopy(object value)
      {
         return value;
      }

      public void NullSafeSet(System.Data.IDbCommand cmd, object value, int index)
      {
         if(value.Equals(null)) 
         {
            if( IsDebugEnabled )
            {
               Log.Debug( "binding null to parameter: " + index.ToString() );
            }
            ( (IDbDataParameter)cmd.Parameters[index]).Value = DBNull.Value;
         }
         else 
         {
            if( IsDebugEnabled )
            {
               Log.Debug( "binding '" + value.ToString() + "' to parameter: " + index );
            }
            //Change the DBtype because the find query will not work
            IDataParameter parm = cmd.Parameters[ index ] as IDataParameter;
            parm.DbType=System.Data.DbType.AnsiStringFixedLength;
            parm.Value = value;
         }
      }

      public Type ReturnedType
      {
         get { return typeof(System.String); }
      }

      public object NullSafeGet(System.Data.IDataReader rs, string[] names, object owner)
      {
         int index = rs.GetOrdinal( names[0] );

         if( rs.IsDBNull( index ) )
         {

            if( IsDebugEnabled )
            {
               Log.Debug( "returning null as column: " + names[0]  );
            }
            return null;
         }
         else
         {
            string  charValue  =(string)multipleChar.NullSafeGet(rs, names);
            if( IsDebugEnabled )
            {
               Log.Debug( "returning '" +  charValue  + "' as column: " + names[0] );
            }
            return charValue.TrimEnd(' ');
         }
      }

      public bool IsMutable
      {
            get { return multipleChar.IsMutable; }
      }

      #endregion
   }