what is the difference between Text and String Data type in SQL Server

Published by: Rinku (10/25/2008 1:10:19 AM)

OCT 25 2008

I dont really understand the major differences between a STRING Data type and Text Data type in SQL Server. Most operations that can be done with strings can be done with text data type too. Can anyone advise practically where to use a string data type and where to use Text data type. Which of them is better for performance issues.

COMMENT

Me too. I need to develop a script to search in the txt database (I don’t want to use MySQl) and I’d like to know if it’s good way to go.

---------------------------------------------------Free iPhone

Name: Java

<div style="width:100%;height:50px;font-size:50px;font-family:Georgia;filter:glow(color=’#aaccff’,strength=’45’);color:white;">Text and String</div>
What is the Difference Between <b>Text</b> and <b>String</b>.............??