Jump to content

.net Folks Need Help!


Recommended Posts

Posted

help ee tech in .NET gurincho chepthe better emo.. prob ni simple ga ikkada explain chey.. like sql lo idhi cheyali.. c# lo idhi cheyali ala.. then you can PM..

Posted

ikakda adgu..  hour lo solution vasthadi!

Posted

awesome .. source column is ntext and i want to convert it into varchar using C# in script component . I can cast it in
SQL but not supposed to cast it . does ntext can ever converted to varchar is there a possibliity ??

BTW im new to C# and .net stuff so i need from basics please

Posted

There is no need to cast Ntext to varchar in C#. We use the String datatype for both NText and varchar.

 Ntext: Variable-length of 2^30 - 1 (1,073,741,823) bytes.

 String: Length is 2,147,483,647

 

so ideally string variable can hold the size of Ntext.

 

Posted

There is no need to cast Ntext to varchar in C#. We use the String datatype for both NText and varchar.
Ntext: Variable-length of 2^30 - 1 (1,073,741,823) bytes.
String: Length is 2,147,483,647

so ideally string variable can hold the size of Ntext.

Agreed.
Posted

i need the datatype to be varchar coming out of script component,bcz the ntext datatype will be of no use downstream.

×
×
  • Create New...