DataSet Max Length Compared to Oracle Varchar2

[maloney1]

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

 

[Ignacio Machin ( .NET/ C# MVP )]

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