pakapblog!

you know where to find the effing tab key guys, useeeee iiiit!

mysql and character collation - Illegal mix of collations error

I’ve been bitten by this many times and always got stuck on it. mysql complaining about “Illegal mix of collations (latin1_swedish_ci, IMPLICIT) and (utf8_general_ci, COERCIBLE) blah blah”. In order to pinpoint the problem columns and tables you should replace the appropriate collation depends in your error.

Having done this the illegal collation error ceased appearing. All database tables and queries upon them should be consistent - and in most cases should be UTF-8.

And then I set the default collation of mysql server, here’s an example for the [mysqld] section of your my.cnf:

skip-character-set-client-handshake
collation_server=utf8_unicode_ci
character_set_server=utf8

my bash aliases for git and cake console

.bashrc

# git
alias gf='git fetch'
alias gm='git merge'
alias gp='git push origin'
alias gd='git diff'
alias ga='git add'
alias gc='git commit -m'
alias gco='git checkout'
alias gb='git branch'
alias gs='git status'

#cake
alias ck='./cake/console/cake'

Usage :

kewlburn@localhost:~/cake$ ck


Welcome to CakePHP v1.2 Console
---------------------------------------------------------------
Current Paths:
 -app: app
 -working: /home/kewlburn/extanet/psdtohtmlcss/app
 -root: /home/kewlburn/extanet/psdtohtmlcss
 -core: /home/kewlburn/extanet/psdtohtmlcss

Changing Paths:
your working path should be the same as your application path
to change your path use the '-app' param.
Example: -app relative/path/to/myapp or -app /absolute/path/to/myapp

Available Shells:

 APP/vendors/shells:
     project

 ROOT/vendors/shells:
     - none

 CORE/console/libs:
     acl
     api
     bake
     console
     i18n
     schema
     testsuite

To run a command, type 'cake shell_name [args]'
To get help on a specific command, type 'cake shell_name help'

kewlburn@localhost:~/cake$ gs
# On branch develop
nothing to commit (working directory clean)
kewlburn@localhost:~/cake$ gf
Already up-to-date.