SQL - bp insert special characters with UPPER

Hello

I have little concern, as I explain below:
I have to insert data into a database, data must be converted to uppercase.
So far, so simple: INSERT UPPER ....

The problem is that these data, I have special characters like '°', which after being capitalized are transformed into 'question in reverse.

Someone is not how to avoid it, knowing that compulsion to insert the data in capitals must be respected?

is not a problem of encoding?

I think not.

In fact, I retrieves data from a source, to put them in another basis (decision), the two databases using the same encoding. Unlike a base to another is that some fields are in capital letters (which is a constraints). And it was during this passage capitalized I explained the problem.

I wondered for example, if there was not a SQL function (which I would not know) that 'leap-frog' the characters in the upper, or at least leave them as they are. I have not tested, but I think I have the same problem with accented characters, and the 'C', etc ...

Seen and approved ...

Until someone finds the solution with UPPER, I suggest you use TRANSLATE:

Code:

---

SELECT TRANSLATE ( 'rastadd', 'abcdefghijklm', 'ABCDEFGHIJKLM')
FROM DUAL;

---

Good point, I will test it and see