puli_keka Posted April 15, 2014 Report Posted April 15, 2014 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..
kick_seenu Posted April 15, 2014 Report Posted April 15, 2014 ikakda adgu.. hour lo solution vasthadi!
libraguy863 Posted April 15, 2014 Author Report Posted April 15, 2014 awesome .. source column is ntext and i want to convert it into varchar using C# in script component . I can cast it inSQL 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
Yevadu Posted April 15, 2014 Report Posted April 15, 2014 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.
kajal Posted April 15, 2014 Report Posted April 15, 2014 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,647so ideally string variable can hold the size of Ntext. Agreed.
libraguy863 Posted April 15, 2014 Author Report Posted April 15, 2014 i need the datatype to be varchar coming out of script component,bcz the ntext datatype will be of no use downstream.
Yevadu Posted April 21, 2014 Report Posted April 21, 2014 Hi Guys, i am new to this DB. Recently i posted an article regarding HTML5 geolocation in my blog. Please visit and let me know your valuable suggestions. http://vsaditya.blog...eolocation.html You can also download the code from my blog
Recommended Posts