Sql-ce: ntext data type

Thread is closed for posting
2 posts, 0 answers
  1. Peter
    Peter avatar
    4 posts
    Member since:
    May 2009

    Posted 09 Feb 2011 Link to this post


    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" />

    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.

  2. Ady
    Ady avatar
    589 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,
    the Telerik team
    Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
Back to Top