DataSet Max Length Compared to Oracle Varchar2

  • Thread starter Thread starter maloney1
  • Start date Start date
M

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
 
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
Click to expand...

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