This question is locked. New answers and comments are not allowed.
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:
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:
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
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