The security issues in database are growing very fast as the attackers and hackers are trying everything to compromise the security of the database. The confidentiality of the database is one of the most important aspects that needed to be maintained. One of the most effective ways to maintain the database confidentiality is Encryption. One method to achieve the standard encryption is user supplied key based encryption because this encryption technique provides the cipher text whose length is different in comparison to plain text. But it have one major shortcoming one plain text character is converted into same cipher text for its entire occurrence. In this paper we proposed the modified user supplied key based encryption in which we have all the benefits of user supplied key based encryption and at the same time it provides different characters in cipher text for different occurrence of the same plain text character.