Problem with ntext

There is an issue, that was created during the last nightly build (2007/03/12), that a ntext field in the database can hold only 16 bytes. So if you have a ntext field and you try to save the object in the database you will get an error.

 Error :
"DocumentBody can not exceed 16 characters" 

 "DocumentBody" is the field Name.
 

What version of CodeSmith are you using?

On 3/13/07, geochatz wrote:
>
>
> There is an issue, that was created during the last nightly builds, that a
> ntext field in the database can hold only 16 bytes. So if you have a ntext
> field and you try to save the object in the database you will get an error.
>
> Error :
> "DocumentBody can not exceed 16 characters"
>
> "DocumentBody" is the field Name.
>
>
>
>

I am using 4.0.0 Rev 1724 , but with the previous nightly build (2007/03/08) there was no problem!!

Hello

-has this been fixed ?  as i am getting the same error!

thanks 

 

nettiers nightly build 20070316

codesmith version = 4.02  rev1774

No the bug is still there

This is the problem:

In the latest version of TemplateLib/CommonSqlCode.cs we have:

  /// <summary>
  /// Determines whether base DataObjectBase is a string type, and not a blob column of text or ntext
  /// </summary>
  public bool CanCheckLength(SchemaExplorer.DataObjectBase column)
  {
   switch (column.DataType)
   {
    case DbType.AnsiString:
    case DbType.AnsiStringFixedLength:
    case DbType.String:
     return (column.Size != -1);
     break;
    case DbType.StringFixedLength:
     return
     (
      column.NativeType != "text" &&
      column.NativeType != "ntext" &&
      column.Size > 0
     );
     break;
    default:
      return false;
   }
  }

 

This used to be:

  /// <summary>
  /// Determines whether base DataObjectBase is a string type, and not a blob column of text or ntext
  /// </summary>
  public bool CanCheckLength(SchemaExplorer.DataObjectBase column)
  {
   switch (column.DataType)
   {
    case DbType.AnsiString:
    case DbType.AnsiStringFixedLength:
    case DbType.String:
    case DbType.StringFixedLength:
     return
     (
      column.NativeType != "text" &&
      column.NativeType != "ntext" &&
      column.Size > 0
     );
     
    default:
      return false;
   }
  }

However, ntext is of type DbType.String and have a 'field lenght' of 16...

this bug has been reported http://tracker.nettiers.com/issue/ViewIssue.aspx?ID=163 but has not yet been resolved :(