Можно использовать tar с "z" аргументом
tar xvfz mytar.tar.gz
select ignored+0 from table;
select cast(ignored as unsigned) from table;