0

I see nclob data in editor of oracle pl sql developer as

Detayları resmi yazı ile iletilen tüberküloz ...

But I want to decode this into 

Detayları resmi yazı ile iletilen tüberküloz ...

My sql query is like:

SELECT T.Aciklama "AÇIKLAMA",
...

How should I change my query to result as true decode.

serefbilge
  • 1,654
  • 4
  • 29
  • 55
  • Seeing HTML entities in a Oracle database makes me think that data comes from an HTML form and the HTML document's encoding doesn't support Turkish characters. – Álvaro González Mar 11 '13 at 16:22
  • I tried to export it to excel with query and some c# code, result is same in excel. – serefbilge Mar 11 '13 at 17:34
  • 1
    You could simply `replace(source_string, 'ü', 'ü')` and repeat the same for all special html codes of your alphabet. – Egor Skriptunoff Mar 11 '13 at 17:36
  • @serefbilge - Of course, exporting data does not alter data unless done wrong. I was just suggesting that perhaps you can store correct data in the first place. If that's not an option, I'm pretty sure C# can decode HTML entities. – Álvaro González Mar 11 '13 at 17:48
  • @ÁlvaroG.Vicario - I use fck editor, and it makes it like that, it parses right when editing. Then, the problem occured when transport to excel needed. I should decode nclob to right format with query. – serefbilge Mar 11 '13 at 19:54
  • Er... CKEditor is an HTML editor so you'll also have HTML tags like `

    ` or ``, won't you? Your data is HTML so you just handle it as such. Again, SQL is not a good tool to process HTML.

     – Álvaro González Mar 11 '13 at 20:40
  • There is no problem with fck editor, the problem is with exporting to excel. To see it in excel in right format, I need to decode it into turkish chars. – serefbilge Mar 12 '13 at 07:10

0 Answers0