Unicode Character support in MySQL 3.23.52?

[Milesh Dcunha]

Hi,

I am usin Mysql Version 3.23.52 and Tomcat (version unknown) and JSP for web development.
MySQL provides PASSWORD function for encryption but no decryption function. Hence, I wrote a small function to encode characters by adding 50 to their ascii value.
Now, after conversion I store the data in MysqL and then I fetch it and convert it back by subtracting 50 to it's ascii value. But, it seems to miss some of the characters.

Can it be cause the characters are getting converted to some ASCII value not representable in the default character set.
I don't know how to specify a different character set for a particular column.
Please also tell me which character set to use?

OS: Windows 2000



Edited 2 time(s). Last edit at 01/31/2006 10:26PM by Milesh Dcunha.