Msg#: 4095111 posted 2:12 am on Mar 11, 2010 (gmt 0)
Does any one recommended MySQL data type for screen resolutions besides varchar? Basically entries would be no larger then 2560x1600 or nine characters. I could use INT however removing the separator would require processing the number in PHP later unless someone has something I'm not aware of to recommend?
Msg#: 4095111 posted 3:13 am on Mar 11, 2010 (gmt 0)
Thanks for your reply. I setup a column and tested out the code you posted successfully! :)
Essentially I've created an authentication log to deal with any potential social related issues so I will be seeing let's say about 100 entries per person per incident when there is an incident as the admin, no one else will be accessing this MySQL in any way.
The largest concern I have (due to the Oracle envelopment...err I mean acquisition of Sun) is being able to port to a different flavor of SQL. I've only been working with MySQL for a couple years so my question is simply this: would this require much if any significant changes if/when I switched to a different SQL database such as PostgreSQL?