Sql-ce: ntext data type

2 posts, 0 answers
  1. Peter
    Peter avatar
    4 posts
    Member since:
    May 2009

    Posted 09 Feb 2011 Link to this post

    Hi,

    I think there is a bug in the reverse mapping wizard of open access (for sql ce database):

    Mapping a ntext field results in the following mapping configuration:

    <field name="description">
      <extension key="db-column">
        <extension key="db-type" value="CLOB" />
        <extension key="db-column-name" value="Description" />
      </extension>
    </field>

    But with this configuration all texts get truncated after 218 characters (-> 3488 bytes with UTF-16).
    After manually adding a "db-sql-type" entry to the configuration of all ntext fields it worked for me:

    <extension key="db-sql-type" value="ntext" />

    A forum post at msdn lead me to this solution: http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/9fe8e826-7c20-466c-8140-4d3b0649ac09.

    Greets,
    Peter
  2. Ady
    Admin
    Ady avatar
    588 posts

    Posted 10 Feb 2011 Link to this post

    Hi Peter,

    Thank you for pointing that out. We could reproduce the problem and will fix it.

    Kind regards,
    Ady
    the Telerik team
    Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
  3. DevCraft banner
Back to Top