Replace command not working [message #587726] |
Tue, 18 June 2013 05:19  |
nmd_group
Messages: 21 Registered: February 2012 Location: Dhaka,Bangladesh
|
Junior Member |
|
|
database 10GR2, Character_set WE8ISO8859P1
The following command not working.
update consumerappliedform
set name =replace (name,'¿','‡');
What is the problem.
|
|
|
|
|
Re: Replace command not working [message #587737 is a reply to message #587732] |
Tue, 18 June 2013 05:50  |
 |
Michel Cadot
Messages: 68770 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Because it is not a real ¿.
It is just a replacement character displayed because your local character set does not support the actual one.
Regards
Michel
|
|
|