Cryptical characters in database


#1

Hello,

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 www.sensational-marketing.de

Do you know how I can resolve this problem?

Greets
Bastian


(Matthieu Aubry) #2

see SQL query in the topic: 301 Moved Permanently


#3

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?