blog.dbrgn.ch

Entries tagged “databases”

June 18, 2010

Change MySQL Database Encoding

To change MySQL table column encoding: ALTER TABLE artists CHANGE [fieldname] [fieldname] [fieldtype] CHARACTER SET ...
June 16, 2009

Storing an IP in MySQL

Summary Datatype:int(4) unsigned Storing IP:INET_ATON('192.168.1.39') Getting IP:INET_NTOA ...