Whilst populating a text field in an oracle7 database, I get the # character inserted instead of a £. I guess this happens for any character > ascii 127. How can I prevent this when inserting and how can I replace the # for a £ when retrieving exisitng data during a query? A replace(table.textfield,'#','£') does nothing. steve.campbell@autotrader.co.uk
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
hash (#) character instead of pound (£) in text field
- Thread starter sophic
- Start date
Similar threads
- Locked
- Question