Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Possible data corruption??
Message
General information
Forum:
Microsoft SQL Server
Category:
Recovery
Miscellaneous
Thread ID:
00699935
Message ID:
00700332
Views:
14
I tnink you can use binary or varbinary data type to store such data.

>I found the problem...
>
>It appears that the encryption control they are using to encrypt credit card numbers are putting characters that really screw with MSSQL - It's an ActiveX Control from Silicon Prairie Software. It made SQL Server think that the either the Index or the table was corrupted and wouldn't allow us to pull data from the one particular table. The reason we're not having the same problem with the other databases is because those credit card number are not encrypted. We're gonna have to un-encrypt the credit cards stored in SQL Server in order to avoid the problem, again.
>
>I appreciate all the help you always provide.
>
>Whenever we run into each other I'll have to buy you guys lunch.
>
>Thanks!
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform