Daily Archives: 03.02.11

Concatenating a utf8 char field and a datetime field in mysql

In a database of mine (using mysql 5), I needed to make a ‘fake name’ – concatenating the real name and a datetime, so I did a concat(name, ‘(‘,thetime,’)’) in the sql and got just what I expected TheName (2011.02.02 … Continue reading

Posted in sql | Comments Off on Concatenating a utf8 char field and a datetime field in mysql