[Solved] Sql-ce: ntext data type

[Peter]

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

[Ady]

Hi Peter,

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

Kind regards,
Ady
the Telerik team