Unicode Character support in MySQL 3.23.52?
Posted by: Milesh Dcunha
Date: January 20, 2006 04:31AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Unicode Character support in MySQL 3.23.52?
2522
January 20, 2006 04:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.