What does null terminated character String mean?

• chaithu559

  SSCommitted

  Points: 1574

  More actions

  March 10, 2012 at 5:48 am

  #252248

  Hi Everyone,

  What is a null terminated character string. while i was going through the Integration Service Data types , there's something given like this for DT_STR data type ..

  "A null-terminated ANSI/MBCS character string with a maximum length of 8000 characters. (If a column value contains additional null terminators, the string will be truncated at the occurrence of the first null.) "

  What does this mean .. Please put on an example to explain this .

  thanks and regards

  chaithanya M

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  March 12, 2012 at 12:42 am

  #1457676

  http://en.wikipedia.org/wiki/Null-terminated_string

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP