Home » SQL & PL/SQL » SQL & PL/SQL » Replace command not working (Oracle 10GR2)
Replace command not working [message #587726] Tue, 18 June 2013 05:19 Go to next message
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 #587728 is a reply to message #587726] Tue, 18 June 2013 05:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What "is not working" mean?

Regards
Michel
Re: Replace command not working [message #587732 is a reply to message #587728] Tue, 18 June 2013 05:28 Go to previous messageGo to next message
nmd_group
Messages: 21
Registered: February 2012
Location: Dhaka,Bangladesh
Junior Member
it is not changing columns character from ¿ to ‡
Re: Replace command not working [message #587737 is a reply to message #587732] Tue, 18 June 2013 05:50 Go to previous message
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
Previous Topic: NUMBER SERIES (merged by MC)
Next Topic: SQL QUERY ERROR help
Goto Forum:
  


Current Time: Thu Sep 04 23:29:14 CDT 2025