http://www.deals2buy.com/
Author Archive
Permalinks on IIS6 (without mod_rewrite)
Pretty Permalinks are SEO / Human friendly urls for your blogs. Wordpress uses mod_rewrite module which is not supported by IIS.
If you are using IIS7 and have administrative privileges you can use Microsoft’s URL Rewrite Module , Read this for more information.
This article briefs about the technique used to make the permalinks work with IIS6.
A few maximum limitations for Sqlserver and MySql
Often people in newsgroups ask about maximum size of various objects defined in databases.
The following tables shows the maximum sizes and numbers of various objects defined in MYSql, SQL Server.
| Char | 255 Bytes |
| Varchar | 65,535 Bytes |
| Binary | 255 Bytes |
| Varbinary | 65,535 Bytes |
| TinyBlob | 255 Bytes |
| TinyText | 255 Bytes |
| Blob | 65,535 Bytes (2^16 -1) |
| Text | 65,535 Bytes (2^16 -1) |
| Medium Blob | 16,777,215 Bytes (2^24 -1) |
| Medium Text | 16,777,215 Bytes (2^24 -1) |
| LongBlog | 4,294,967,295 Bytes (2^32 -1) |
| LongText | 4,294,967,295 Bytes (2^32 -1) |
| Bit | Range from 1 to 64 |
| Tinyint | The signed range is -128 to 127. The unsigned range is 0 to 255. |
| BOOL, BOOLEAN | true or false |
| SmallInt | The signed range is -32768 to 32767. The unsigned range is 0 to 65535. |
| MediumInt | The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215. |
| Int/Integer | The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295. |
| BigInt | The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615. |
| Float | Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38. |
| Double | Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308. |