Quote from: John Tobey on April 29, 2014, 09:23:20 PM

Quote from: dasource on April 25, 2014, 06:07:00 PM

Anybody else noticed that when you use "policy" "NovaCoin" or a clone of it that the database stores really random data? Yet the explorer displays it perfectly?

Take a look at this :
http://explorer.information-coin.com/block/5bf9c6ba1f6e893a50141040601bf0fbeddffab6dd03f125c3434c41eed9e7d3

Code:

mysql> select * from block where block_id=5634;
+----------+----------------------------------+---------------+----------------------------------+-------------+-------------+--------------+--------------+---------------+-----------------+----------------------------------------+----------------+-----------------+----------------------+---------------------+-----------------------+----------------------+--------------+--------------------+
| block_id | block_hash | block_version | block_hashMerkleRoot | block_nTime | block_nBits | block_nNonce | block_height | prev_block_id | search_block_id | block_chain_work | block_value_in | block_value_out | block_total_satoshis | block_total_seconds | block_satoshi_seconds | block_total_ss | block_num_tx | block_ss_destroyed |
+----------+----------------------------------+---------------+----------------------------------+-------------+-------------+--------------+--------------+---------------+-----------------+----------------------------------------+----------------+-----------------+----------------------+---------------------+-----------------------+----------------------+--------------+--------------------+
| 5634 | =ô÷!Å·aí3Ï²
ApÀ½+----------+----------------------------------+---------------+----------------------------------+-------------+-------------+--------------+--------------+---------------+-----------------+----------------------------------------+----------------+-----------------+----------------------+---------------------+-----------------------+----------------------+--------------+--------------------+
1 row in set (0.00 sec)

I've been able to reproduce this with half a dozen different coins, yet when I change it from NovaCoin to X11 or Sha256 the data in the DB shows as normal....

Are you sure it depends on policy? Recently I changed Abe to use binary data types by default. To get the old behavior, configure binary-type=hex.

Hmm, I was sure it was; I will double check.
I have set binary-type=hex in abe.conf but the DB still shows the same; Have tried on two different setups. Deleted the Database and re-created it.

EDIT binary-type=hex (and binary) works fine on a old version of Abe but not on the latest version; always seems to store in binary.

EDIT Was able to fix this by editing SqlAbstraction.py and setting 'val = sql.config.get('binary_type')' to 'val = "hex"'. binary_type is not set in the DB on latest release.