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 |
|
Bheenick
Starting Member
2 Posts |
 Posted - 2011-03-31 : 01:47:42
|
| Hi everyone, Am having an issue saving this particular character(">") in SQL Server 2005 in a varchar field.Any hint on how to proceed to save the character as it is instead of ">" in the database!Thanx in advance, CheersImpossible is nothing... |
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-03-31 : 02:22:36
|
| What is your problem exactly See this is working declare @t table (id varchar(6))insert into @t values('">"')insert into @t values('>')insert into @t values('(">")')select * from @tOr --drop table #tdeclare #t table (id varchar(6))insert into #t values('">"')insert into #t values('>')insert into #t values('(">")')select * from #tIf you are not able to store that character then see you have enough space for that column to store values.Raghu' S |
 |
|
|
|
|
|
Saving ">" char in a varchar field