Cryptical characters in database



I want to analyse my data of Piwik also in the database (phpmyadmin). But in the table “piwik_log_visit” and column “idvisitor” are only cryptical characters like �/�/M8. The data is from the website

Do you know how I can resolve this problem?


(Matthieu Aubry) #2

see SQL query in the topic: 301 Moved Permanently


Ok, now I have 3 raws with data, the others are 0. I wrote this script:
SELECT CONV(idvisitor, 16, 10 FROM piwik_log_visit

Do have a solution?