Loading an image using System.Drawing.Image.FromFile and then examining the pixelformat - on Windows XP x64 (or x86) the format is a valid value such as PixelFormat24bppRGB but on Windows 7 (x64 or x86) the value returned is 8207, which is not a member of
the PixelFormat enumeration.
This problem occurs using .NET framework 3.5 and 4.0
The code used is:
using System;
using System.Drawing;
public class itype {
public static void Main( string[] args ) {
Image image = Image.FromFile( args[0] );
Console.WriteLine( "pixelformat of " + args[0] +
" = " + image.PixelFormat );
}
}
An image which shows this problem can be downloaded from
View Complete Post=""
Built-in Functions - Text and Image Functions in SQL Server Text and image functions operate on TEXT, NTEXT and IMAGE data types. These data types are deprecated with SQL Server 2005 and should be replaced by VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) when possible. Alternatively you can also consider storing large string values using XML data type. Text and image functions are nondeterministic. Future versions of SQL Server will not support TEXT, NTEXT and IMAGE data types. Columns with TEXT / NTEXT data type do not support commonly used string functions such as LEN, LEFT, RIGHT, etc. Furthermore, due to the large size of TEXT data you''re likely to see performance issues if you store such data in the database. However, at times you can''t help but use the TEXT / NTEXT / IMAGE data types (for example when supporting 3rd party databases when you cannot change the schema) - this is when text and image functions come in handy.