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 |
|
useem
Starting Member
1 Post |
 Posted - 2011-05-25 : 18:39:28
|
I am inserting data to SQL server DB, I process the values from a string.when i look on the DB, i can find a weired characters. enclosed an image, someone can tell me how can i remove this characters?Thanksuseem |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jfarrugia
Yak Posting Veteran
55 Posts |
Posted - 2011-05-26 : 04:20:32
|
| can you give us further info pls? Maybe code snippet where the insert is occurring?I suggest placing a TRIM in stored procedure if you're using an SP to insert, else go to application and place a TRIM in T-SQL insert or a trim in other code you're using.Where software development knowledge meets the reader |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-05-30 : 06:39:47
|
| I guess they might be a new line, tab, etc charactersMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
problem with SQl server data insert