Hello,

I have a field on an Oracle Database with a max length of 14 Byte, on
my dataset I have a max length for the column on the datatable of 14.
When the Database has an entry higher than 7 characters it is not
appearing inside the dataset.

Is there a mismatch between the Oracle 14 byte length and the max
length value in microsofts Datasets?

Some posts I have read hinted to doubling the MS dataset max length
and then adding two (14 +2 as the max length) this isn't clear why,
does anyone have a good explanation for this?

Thanks
John

On Nov 24, 10:00 am, maloney1 <malon...@gmail.com> wrote:
> Hello,
>
> I have a field on an Oracle Database with a max length of 14 Byte, on
> my dataset I have a max length for the column on the datatable of 14.
> When the Database has an entry higher than 7 characters it is not
> appearing inside the dataset.
>
> Is there a mismatch between the Oracle 14 byte length and the max
> length value in microsofts Datasets?
>
> Some posts I have read hinted to doubling the MS dataset max length
> and then adding two (14 +2 as the max length) this isn't clear why,
> does anyone have a good explanation for this?
>
> Thanks
> John

It might be because in .NET a string is a two bytes unicode char.
Try saving the string as ASCII