Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
eribla
Starting Member
1 Post |
 Posted - 2012-09-01 : 15:54:57
|
| Hinew to the forum, 2 out of 5 grade SQL experience.Here is my question:In our customer service database we have a field with free text input where an agent can write:Got "error 1", looked into \\server\data\test.ini The field is stored into a varchar(max) field but occasionally we get strange errors that most likely are caused by a combination of the special characters " \ ', but we could not put our finger on the exact cause.What field type is suggested for this kind of data?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-02 : 12:32:09
|
| the problem may be the way you use the data rather than storing it. varchar(max) doesnt seem to be cause for this.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Field type for special characters