search

vina92 / xbt

Automatically exported from code.google.com/p/xbt
0 stars 0 forks source link

SQL CONTAINS INVALID FORMAT #2

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Hi... first i want to thank you for doing this kind of tracker, i/we will 
really appreciate it!

my issue:

i have installed your XBT tracker successfully on WindowsXP

but when i try to put Auto_register = 1 it will register the torrent file but 
info_hash filed contains the unknown and unreadable format

real info hash = '60ab2a125e54b50b07c9377e664b4a99d4a9dc20'
database info_hash when field is (VARCHAR) = `«*^TµÉ7~fKJ™Ô©Ü)
database info_hash when field is (BINARY) = 
0ab2a125e54b50b07c9377e664b4a99d4a9dc200000000000000000000000000000000000000000

when field is BINARY it looks like okay but when i try to search the info hash 
its not searching... :(

hope you help me in this issue

Thanks
-Thilina-

Original issue reported on code.google.com by heppuwa....@gmail.com on 13 Mar 2011 at 7:23

GoogleCodeExporter commented 8 years ago 
How do you search? You probably have to use the hex/unhex functions.

Original comment by olafvdspek on 13 Mar 2011 at 2:40