MD5 Hash code is a unique string of characters that can be generated for a given character string. This Hash code is very important when you compare string values. It is not technically correct to compare two string directly. Good method is generate Hash code for both the strings and compare those Hash codes. Virtually it is agreed that accuracy of Hash code comparison is much higher. Not only to compare two strings, we can use Hash code to compare two files as well. There it is required to read a file as byte stream and generate Hash code for that stream. To compare that stream with second file you need generate Hash code for second file as well using same method and compare those Hash codes. Using this method you can check whether any changes has happened to the content of the file as well as meta data of the file. So that MD5 Hash code is really important in various scenarios. Most of the programming languages are directly support for MD5 generation. Even SQL commands are available to generate Hash code directly at database level. Here I am explaining one of the methods that can be easily used.
Tuesday, 5 January 2010
Tags
Continue Reading
Figure 1: Structure of drive system
Load is the most important component. All other units are arranged to serve the requirement of the load. Any design begins with a list of specifications for the load. This depends on the type of the load and its environment. We need to answer several questions before preparing specifications.
Tags
Continue Reading
Role of power electronics and drivers
- Power controlling using electronics consider here
- Signal controlling is consider about controlling information
Power electronics is about control of power electronically. Range of power can extend from some fraction of watt to several mega watts (MW). Drives are about the control of mechanical motion. It can be a linear motion, rotary motion or their combination. There is a greater compatibility between power electronics and drives as the former can provide smart control of power for the drives. This is evident from the varieties of fascinating motion control systems we find today.
Tags
Continue Reading
Monday, 29 June 2009
If you try to insert single quote into DB2 sql table directly, it will give an error message due to single quote is reserved for mark a string value in sql. It is not allowed to use escape sequence for single quote with sql. Below example is incorrect with sql syntax.
INSERT INTO CUSTOMERS ( COMPANY_NAME ) VALUES ('Nandun\'s Company')
Here middle single quote is not valid even it has used the escape sequence. The easiest method to insert single quote into sql table is replace single quote with double quote.
INSERT INTO CUSTOMERS ( COMPANY_NAME ) VALUES ('Nandun\"s Company')
In second example I have replaced the single quote with double quote, but once you execute this command it will insert single quote instead of double quote.
You can use following code in C#.NET to replace single quote with double quote.
Replace("\'", "\"")
If you have any question you can list them under comments section.
INSERT INTO CUSTOMERS ( COMPANY_NAME ) VALUES ('Nandun\'s Company')
Here middle single quote is not valid even it has used the escape sequence. The easiest method to insert single quote into sql table is replace single quote with double quote.
INSERT INTO CUSTOMERS ( COMPANY_NAME ) VALUES ('Nandun\"s Company')
In second example I have replaced the single quote with double quote, but once you execute this command it will insert single quote instead of double quote.
You can use following code in C#.NET to replace single quote with double quote.
Replace("\'", "\"")
If you have any question you can list them under comments section.
Tags
Continue Reading
Monday, 8 June 2009

Tags
Continue Reading
Thursday, 28 May 2009
Are you a graphic designer, web designer or digital artists who is paying back most of your income for software tools that you are using for your creations? What will be your net income if you could save money that you are paying for those software tools? Yes, there are tons of free tools that you can use as alternative graphic software tool. Some of the free tools having rich set of functions than commercial tools, but most of the people are having lack of knowledge about them and their features. So, I decided to introduce few of them that I am using for my creations without paying any dollar for any company. That means cost for my creations are negligible and income is really high.
Tags
Continue Reading
Sunday, 24 May 2009
Are you tired in writing complex code for your database design? Want to be little relax? This article will help you to enjoy your job.
In early days we had to write coding from the scratch to implement our database designs. Later people moved to database designing graphical tools. The latest trend of designing databases is use database navigation maps where you can visually feel your database design. This method is very useful if your database is little complex and you have lot of key constraints, referential integrity constraints, indexes and triggers etc. Using database navigation maps you can see either the entire database or part of it, how the tables are integrate each other, what are the keys you have defined for tables and references etc. Most importantly you don't need to write any single code or no need to remember complex SQL syntax.
Tags
Continue Reading
Thursday, 21 May 2009
In my previous article, we discussed on how to generate XML document or XML stream from your dataset. There I mentioned that one of the major advantage of converting a dataset into XML is we can easily validate our XML data against the XML schema. The XML schema is used to define the format, data types and key constraints that you want to validate. The XML document or XML stream can be validate against the predefined XML schema and exactly you can get the validation error and on which tag that error is occurred.
First you need to have a XML document to validate. There are several ways to convert your data into XML documents. In previous article I showed you one such method. In this article I will show you how to do a validation with XML schema for existing XML document.
First you need to have a XML document to validate. There are several ways to convert your data into XML documents. In previous article I showed you one such method. In this article I will show you how to do a validation with XML schema for existing XML document.
Tags
Continue Reading