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 |
|
duhaas
Constraint Violating Yak Guru
310 Posts |
 Posted - 2006-10-31 : 08:36:34
|
| From what I can tell the value in my two table are identical, but when i conver them to binary, something is different:EXCEPTION TABLEMMAS-I011 0x4D4D41532D493031310D0AMMAS-I020 0x4D4D41532D493032300D0ACategorytableMMAS-I011 0x4D4D41532D49303131MMAS-I020 0x4D4D41532D49303230Whats the end binary string telling me (0D0A) |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-31 : 08:37:30
|
0D is Carriage Return0A is Line Feed
KH |
 |
|
|
duhaas
Constraint Violating Yak Guru
310 Posts |
Posted - 2006-10-31 : 08:39:47
|
| YOU DA MAN |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-10-31 : 09:08:58
|
| Also note that if the values are in different cases, you will find difference when casting to varbinarySelect cast('test' as varbinary(100)),cast('Test' as varbinary(100))MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Somthing is different