Yes, I knew about it.
Yet, this gives me 2 problems:
- increase of 32 char to 64 char for storing the hash. Maybe I should store
this in a different way, like binary to save half the space?
- I cannot figure out how to have the same results between hash() in H2 and
sha256 from OpenSSL/ruby
As said, I use ruby and in ruby OpenSSL::Digest::Digest.new("sha256") == "
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"
Could you please show me how to get the same value using hash() in H2?
I tried call hash('SHA256',stringtoutf8('sha256'),1) without success...
Regards,
Christian
On Thursday, April 19, 2012 6:04:36 PM UTC+2, Thomas Mueller wrote:
>
> Hi,
>
> H2 supports SHA256 natively, I would use it instead of MD5:
> http://h2database.com/html/functions.html#hash
>
> Regards,
> Thomas
>
>
>
>
> On Saturday, April 14, 2012, Christian MICHON wrote:
>
>> On Friday, April 13, 2012 9:51:52 PM UTC+2, Christian MICHON wrote:
>>>
>>> Hi,
>>>
>>> I need to detect repetitions and updates in (relatively) small H2 tables.
>>>
>>> As such, I currently implemented using ruby and an external ORM a md5sum
>>> calculation of all the keys concatenated into a string following their
>>> natural order, which is stored back into a specific key.
>>>
>>> This involves a lot of communication with the H2 server, and I wish to
>>> have it done natively (using java itself).
>>> (...)
>>>
>>>
>> After many experiments, I finally cracked it.
>>
>> Sharing it here, in case someone else finds this useful one day...
>>
>> CREATE ALIAS MD5 FOR
>> "org.apache.commons.codec.digest.DigestUtils.md5Hex(java.lang.String)";
>> CREATE TABLE TEST(ID IDENTITY, NAME VARCHAR(255), MD5 VARCHAR(32) AS
>> MD5(NAME));
>> INSERT INTO TEST (NAME) VALUES('The quick brown fox jumps over the lazy
>> dog');
>> SELECT * FROM TEST ORDER BY ID;
>>
>> Really powerful tool this H2 db... Congratulations again...
>>
>> Christian
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msg/h2-database/-/UV44utlLiAYJ.
>> To post to this group, send email to [email protected].
>> To unsubscribe from this group, send email to
>> [email protected].
>> For more options, visit this group at
>> http://groups.google.com/group/h2-database?hl=en.
>>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/hKjo_lpbiA8J.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
