This is a migrated thread and some comments may be shown as answers.

Sql-ce: ntext data type

1 Answer 71 Views
Databases and Data Types
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Peter
Top achievements
Rank 1
Peter asked on 09 Feb 2011, 01:10 PM
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

1 Answer, 1 is accepted

Sort by
0
Ady
Telerik team
answered on 10 Feb 2011, 05:17 PM
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.
Tags
Databases and Data Types
Asked by
Peter
Top achievements
Rank 1
Answers by
Ady
Telerik team
Share this question
or