Month: July 2013

MySQL convert to utf8

Naveen Nayak July 31, 2013 No Comments MySQL

A quick way to convert your database to utf8 # Dump the old database as latin1, mysqldump defaults to utf8 mysqldump -h host -u user -p –default-character-set=latin1 old_db > dump.sql # Rewrite the dump to say ‘utf8’ and ‘utf8_general_ci’ sed -e ‘s/SET NAMES latin1/SET NAMES utf8/g’ -i dump.sql sed -e ‘s/DEFAULT CHARACTER SET latin1/DEFAULT CHARACTER […]

DataTables with Twitter Bootstrap FixedColumns not working

Naveen Nayak July 11, 2013 No Comments Tips and Tricks, Web Development

DataTables integrates very well with Twitter Bootstrap and the results look amazing. I was tinkering with the two and ran into a problem when using the FixedColumns plugin. Whenever I used bootstrap.css, the horizontal scroll bar would disappear. After searching around for a long time, found that bootstrap table property of max-width is the culprit. So just […]

Page 1 of 1