special characters [message #21757] |
Wed, 28 August 2002 12:12 |
Krijn Michiels
Messages: 4 Registered: August 2002
|
Junior Member |
|
|
Hello,
We had some troubles with special chars in Oracle. Now we have solved it, but the old data needs to be transformed. For example : the square char was saved as ², the ë char was ö.
We made a conversion routine using the replace method and it works great. The only problem are the capitals.
For example 'Belgiö' becomes 'belgië'.
Question: How can I use replace without changing the capital of a word.
Thanks
|
|
|
Re: special characters [message #21765 is a reply to message #21757] |
Wed, 28 August 2002 13:22 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
How can it change if you don't code it to change?
select ascii('B'), ascii('b'), ascii('ë'), ascii('ö') from dual;
select 'Belgiö',
replace('Belgiö', chr(101), chr(111)),
replace('Belgiö', 'ë', 'ö') from dual;
|
|
|