PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WINDEV 2024
→
SHA256 of Windev is different to MySQL's
SHA256 of Windev is different to MySQL's
Started by Juan, Jan., 09 2019 4:52 PM - 3 replies
Connect yourself…
Juan
#1
Posted on January, 09 2019 - 4:52 PM
Hello,
I am trying to hash the passwords using:
s
Password
is string
=
"MiContraseña"
s
Clave
is string
=
HashString
(
HA_SHA_256
,
s
Password
)
tmp
is string
FOR i
=
1
_TO_
Length
(
s
Clave
)
tmp
+
=
Right
(
NumToString
(
Asc
(
s
Clave
[
[i]
]
)
,
"08x"
)
,
2
)
FIN
ToClipboard
(
tmp
)
// b536931076054627e24dcebf50140c8374bf80b079fa017e91c72f48e8109eff
If I try
SELECT SHA2
(
'MiContraseña'
,
256
)
it will return '1ef1870f76d31f4b5e877996faf904fd5214135c9967100ff3eda9f568b4d751', which is obviously different from the output made by Windev 22.
Am I missing something, doing something wrong...?
Thank you.
Report
0
0
Tim
#2
Registered member
34 messages
Popularité : +3 (3 votes)
Posted on January, 11 2019 - 11:03 AM
Hi,
I'm not sure, but could it be that windev uses SHA1 vs SHA2?
Report
0
0
Juan
#3
Posted on January, 11 2019 - 12:52 PM
Hello,
I tried making everything an ANSI String, and it worked.
Apparently the problem here is when you set the strings to UNICODE...
I have still that problem, some passwords will for sure contain special characters, and for some reason, when hashing the same ANSI string in UNICODE it will give a different output... I need to find a fix / workaround for that.
Report
0
0
Rubén Sánchez Peña
#4
Registered member
797 messages
Popularité : +40 (42 votes)
Posted on January, 11 2019 - 6:21 PM
Hi. Well, knowing that, you can convert unicode text into ANSI and vice versa. On the other hand HashString returns a buffer and not a string, since the result can contain non-printable characters.
Grettings
Rubén
Report
0
0
→ Go back to WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text