| How to store special character in database [message #472180] |
Thu, 19 August 2010 03:57  |
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
|
Senior Member |
|
|
Dear friends
i want to store special characters in database. i have tried following but not succeed. So please suggest me the way how to store and retrieve it. Herewith i'm posting my try.I want to store and retrieve following character.
SQL> select nchr(181) from dual;
N
-
µ
SQL> create table temp (uom varchar2(10));
Table created.
SQL> insert into temp values(nchr(181));
1 row created.
SQL> commit;
Commit complete.
SQL> select * from temp;
UOM
----------
?
here i'm getting the '?' but i want 'µ'.
Regards
Jimit
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
