sql checkboxlist currently uses nvarchar for storage which can cause the string or binary data would be truncated error

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Zac 239 posts 541 karma points

Aug 20, 2013 @ 20:03

0

SQL CheckBoxList - currently uses nvarchar for storage which can cause the String or binary data would be truncated error

The file SqlCheckBoxListPreValueEditor.cs forces the Sql CheckBoxList to use Nvarchar. This has size limitations and can lead to the "String or binary data would be truncated" error if a lot of data is stored. (See related older issue: http://our.umbraco.org/forum/using/ui-questions/31965-uComponents-xPath-checkboxlist-String-or-binary-data-would-be-truncated)

I feel that this (and the other Sql List data types) should be changed to use Ntext (line 50, https://ucomponents.codeplex.com/SourceControl/latest#uComponents.DataTypes/SqlCheckBoxList/SqlCheckBoxListPreValueEditor.cs) or have an option to use nvarchar or ntext.

This issue exists in the latest v 5 version (didn't check v6) of uComponents.

Thanks

Copy Link
Lee Kelleher 4026 posts 15837 karma points MVP 13x admin c-trib

Aug 23, 2013 @ 09:09

0

Hi Summit,

I've just checked the source code for the SQL CheckBoxList - and you're right, it does default to using the Nvarchar column for storing the data.

Could you raise this as a bug on our issue tracker please? Then we can schedule a fix for a future release.
https://ucomponents.codeplex.com/WorkItem/Create

Thanks,
- Lee

Copy Link
Zac 239 posts 541 karma points

Aug 23, 2013 @ 15:55

1

Done. Thanks.

Copy Link
is working on a reply...

This forum is in read-only mode while we transition to the new forum.

You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies