Under PostgreSQL, I'm using PersistentDuration for the mapping between the sql type interval & duration but it doesn't work. Another user found the same issue & come with his own class: p...

I am working on an SQL Database, I have a column named "Price". When the database was created the column "Price" was set to NVARCHAR I need to change its type to decimal(18, 2) without losing the d...

I need a way in which I can define the column type at run-time. Here is my code: foreach (DataGridViewColumn column in this.dataGrid.Columns) { ??? //i.e. column.type = checkbox } How can I def...

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 plea...

i got a problem adding a foreign key in mysql (using phpmyadmin). ALTER TABLE `production_x_country` ADD FOREIGN KEY (`country`) REFERENCES `pmdb_0.3.12`.`countries`(`iso_3166_1`) ON DELETE CASCAD...

What's the difference between binary(10) vs char(10)character set binary? And varbinary(10) vs varchar(10)character set binary? Are they synonymous in all MySQL engines? Is there any gotcha to w...

What is the best column type for a URL field for SQL Server? Type: VARCHAR or NVARCHAR? Length? Similar question for MySQL.