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 |
|
joe.ingle
Starting Member
14 Posts |
 Posted - 2003-04-04 : 05:03:08
|
| Hi GuysI'm using RC4 to encrypt passwords in a table, and have noticed something wierd. About 4 in 5 display in EM, the other 1 doesn't appear to be there, but when I click in the cell it appears.Has anyone any idea why this may be? I'm using varchar as the datatype.CheersJoe |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-04 : 05:23:12
|
| It's probably got some chanracter in it which confuses the display.e-m isn't a good way of viewing or updating data.Try looking at the asci codes of the string.The same thing happens to me sometimes if I copy a large string in the result window in qa. Doesn't display until I highlight it.That's why you need to build a user interface :).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
joe.ingle
Starting Member
14 Posts |
Posted - 2003-04-04 : 05:31:03
|
| It's not such a problem really, more of a puzzler. I'm interfacing with ASP, and it's picking the data up which is the main thing, once the app's finnished, no one will ever see the raw data again! I've used this algorithm for some time, and haven't come accross it before.Have a good, sunny w/e.Joe |
|
|
|
|
|
|
RC4 wierdness