Tag Archives: mysql

mysqldump 5.1.36 unable to successfully dump a MySQL database in UTF-8 character encoding issues

Written by james on February 24, 2012 — 4 Comments

Today I had a character encoding problem when importing some data from a mysqldump from a contractor we had hired to do some work. Everything about the dump was fine, the database, tables, and fields were all using utf8_unicode_ci utf8 collation, the dump file was encoded in utf8, and the database I was importing to […]

Posted in | Also tagged character encoding, mysql collation

php mysql collation change script

Written by james on January 4, 2012 — 5 Comments

There are times when we get stuck with bad collations on our mysql tables and we are overwhelmed by having to change them by hand. Well, I have written a php script which will go through all your tables and fields in a database and update them to the collation which works for you. In […]

Posted in PHP | Also tagged character encoding, collation, PHP

simple but useful php base object for mysql table interaction

Written by james on June 20, 2010 — 1 Comment

I started a project creating an online game which involved lots of objects and tables. Rather than rewrite the same code over and over, I decided to create a base object in which i could simple extend the base object to work with any mySQL table by simply listing all the fields. Here is the […]

Posted in PHP | Also tagged extending objects, objects, PHP


	Buckets AWS Bash CSS3 Docker imagick javascript mongodb mysql OSX PHP randoms Scripts Uncategorized Keys animation apple array assertion canvas character encoding CodeIgniter collation CSS3 currency format DotCloud email encoding geospatial gzip imagick imagickDraw ios6 ipad javascript jpg lat lng Mac mongodb mongodb query multiple backgrounds mysql mysql collation nginx number format ob_gzhandler opcache PHP php-fpm png prototype responsive css seg fault sendmail simplexml string format upstream timeout utf-8 xdebug You don’t say? Ilmu Forensik on MacPro 1,1 Mod – Part 1 Ben Burlingham on MacPro 1,1 Mod – Part 1 Robert Goldszer on MacPro 1,1 Mod – Part 1 Daryl on String Functions for Javascript – trim, to camel case, to dashed, and to underscore Remluben on String Functions for Javascript – trim, to camel case, to dashed, and to underscore James Roberts on String Functions for Javascript – trim, to camel case, to dashed, and to underscore Nanch on String Functions for Javascript – trim, to camel case, to dashed, and to underscore Nanch on String Functions for Javascript – trim, to camel case, to dashed, and to underscore

Tag Archives: mysql

mysqldump 5.1.36 unable to successfully dump a MySQL database in UTF-8 character encoding issues

php mysql collation change script

simple but useful php base object for mysql table interaction

Buckets

Keys

You don’t say?