Timeline for Generating MD5 Hash for NVARCHAR and VARCHAR columns across different databases
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 29, 2023 at 13:24 | comment | added | Andy DB Analyst | Not true. It depends on characters and encoding | |
| Jun 29, 2023 at 12:31 | comment | added | Lauren_G | I want to compare the unicode characters across two different database products, but doing so gives different hash values for NVARCHAR. The only way I can get the same HASH is to downsize to varchar on both sides using an explicit CAST... | |
| Jun 29, 2023 at 12:25 | comment | added | J.D. |
This doesn't explain why those NVARCHAR values would be different between database systems though?
|
|
| S Jun 29, 2023 at 6:30 | review | First answers | |||
| Jun 29, 2023 at 7:47 | |||||
| S Jun 29, 2023 at 6:30 | history | answered | nicholas8855 | CC BY-SA 4.0 |