Home » SQL & PL/SQL » SQL & PL/SQL » Language Text Conversion to UTF8 -
Language Text Conversion to UTF8 - [message #160371] Fri, 24 February 2006 14:15 Go to next message
tan_oratech
Messages: 1
Registered: February 2006
Location: US
Junior Member
Hi ,

I am trying to convert the Loaded Frech Text into UTF8,
My Database NLS_CHARACTERSET is UTF8.

The desired output of the text is "Réforme institutionnelle"

However I had loaded the data into my table. I find this is the value before applying the Convert on that Value - "Riforme institutionnelle".

I tried converting the same using the Character set
update tan_test set value = convert(value,'UTF8','WE8ISO8859P1');

update tan_test set value = convert(value,'UTF8','WE8ISO8859P9');

update tan_test set value = convert(value,'UTF8','WE8ISO8859P15');

None of the above helps me in converting the same to the desired Output
"Réforme institutionnelle"

Can anyone help me in giving the right Character set to convert it to French appropriately.

Thanks,
Narayanan.
Re: Language Text Conversion to UTF8 - [message #189594 is a reply to message #160371] Fri, 25 August 2006 03:27 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

What makes You think that the caracterset is not already UTF8`?
"Database NLS_CHARACTERSET is UTF8"

Br
Kim
Re: Language Text Conversion to UTF8 - [message #189661 is a reply to message #189594] Fri, 25 August 2006 08:34 Go to previous message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
Why are you answering questions from 6 months ago?
Previous Topic: group by versus distinct
Next Topic: losing NATIONAL CHARACTERS(blob->clob->table). unistr?
Goto Forum:
  


Current Time: Thu Dec 08 05:56:01 CST 2016

Total time taken to generate the page: 0.06473 seconds