How to store special character (Mathamatical symbols) in Mysql.
Posted by: Mohan S
Date: September 02, 2010 07:10AM

Hi,
I'm using mysql server 5.1. Also I'm using JSP, Spring(MVC) and hibernate in my application for windows platform (Window XP and later version).
I want to store special charaters (Mathamatical operators and scientific notation charater) like ∅∆Β ∞ √ ∑ ≥ ≠ ≤ ≈ μ ϒ ∏. But these chars are stored as ? in the DB.
Till now I've tried following.
1. I've used connection url like
jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8
2. I've tried modifing my table an corresponding column like
a. ALTER TABLE `test`.`mytable` COLLATE = utf8_general_ci ; and
b. ALTER TABLE `test`.`mytable` COLLATE = utf8_general_ci ;

Can anybody please help me to let me know what all changes I need to do to store and retrive these chars from DB.
-Thanks in advance
Mohan

Options: ReplyQuote


Subject
Written By
Posted
How to store special character (Mathamatical symbols) in Mysql.
September 02, 2010 07:10AM


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.