Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.

ID: 29074, Firebird/Interbase UDF to view 32byte values as WideChars

by Ann Lynnworth Email: Anonymous

Takes 32byte result of SHA256 hash and displays as N WideChars for easier reading.
Download Details
FTP  download also available
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
To download this, you must have registered:
A free membership

For Delphi, Version 12.0  to 17.0 75 downloads
Copyright: Open Source or other

Terms of use: Embarcadero use at your own risk disclaimer

Size: 108,912 bytes
Updated on Tue, 16 Oct 2012 17:21:40 GMT
Originally uploaded on Thu, 11 Oct 2012 00:38:38 GMT
SHA1 Hash: 03B660C0C665FCADDD5D124A091BDF94811F8833
MD5 Hash: 58D179E3661DEBAE5BB8E836CFD783C9

    Explore the files in this upload

This provides a User Defined Function ("UDF") that can be added to Firebird or Interbase with the name ViewOctet (or anything you choose when you declare it). The function converts groups of 32bytes into 2 WideChar values, replacing suspicious characters with FFFD for easier reading. See included screenshots to see how much simpler the data appears when viewed this way, in both IBObjects and FlameRobin.

As of 17-Oct-2012, this UDF is NOT a guaranteed way to avoid the "malformed string" error. Results are data dependent.

Whether or not you have any "character set octets" fields in your own tables, you might find this example useful for learning how to develop a UDF that needs to pass an integer, variable length data and return a UTF8String.

For best results, compile it with CodeSite.

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Could not retrieve comments. Please try again later.

Server Response from: ETNACDC03