Why does SQL 2008 all of a sudden want to drop my tables when I go to change the column type from say int to real? This never happened in SQL 2005 to my knowledge. Any insight would be helpful please. ...
What is the best column type for a URL field for SQL Server? Type: VARCHAR or NVARCHAR? Length? Similar question for MySQL. ...
I have several tables with some pretty standard data in each. Can somebody help me optimize them by telling me the best column types for this data. Whats beside them is what I have currently. Number (max length 7) --> MEDIUMINT(8) Unsigned Text (max length 30) --> VARCHAR(30) Text (max length 200) --> VARCHAR(200) Email Address (max len...
In rails migration, if I set text column limit to 16777215, and migrate, mysql creates column of type LONGTEXT, but it should create MEDIUMTEXT, as it can store 16Mb - 1 byte, what is wrong (log says that create table column is sent with type text(16777215), so it is something wrong with mysql)? Also spending some time gave me, that maxi...
Hi there, Just one little question. Shall i put the HTML textarea content into a DB or a flat file? The textarea content can be very long (like an article or a project). Thanks for helping. Silvio. ...
There is a way to use a Single Line text field when creating a column in Sharepoint Services 3.0 and that field behaves as a Paswword field (hiding what the user entered) ? Thanks in advance! ...