OraFAQ Forum: SQL & PL/SQL » How to update character set of a excel sheet through pl/sql

Home » SQL & PL/SQL » SQL & PL/SQL » How to update character set of a excel sheet through pl/sql (PL/SQL Release 11.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to update character set of a excel sheet through pl/sql [message #599314]

Wed, 23 October 2013 10:38

Chinmay91
Messages: 15
Registered: July 2013
Location: Mumbai

Junior Member

Hi All,

I am extracting Russian characters from db through a procedure and generating one excel sheet. But unfortunately in extracted excel sheet, I have to change the character set manually to "UNICODE(UTF-8)" , otherwise I can't able to see Russian character. Please find the attached screenshot for the same. Is anybody aware how to update this character set through pl/sql ? Let me know if anything needs to be provided from my end.

Thanks in advance.

Attachment: Character set.JPG
(Size: 56.73KB, Downloaded 4481 times)

Report message to a moderator

Re: How to update character set of a excel sheet through pl/sql [message #599317 is a reply to message #599314]

Wed, 23 October 2013 11:00

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Using CONVERT function?

Report message to a moderator

Re: How to update character set of a excel sheet through pl/sql [message #599319 is a reply to message #599314]

Wed, 23 October 2013 11:30

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Chinmay91 wrote on Wed, 23 October 2013 21:08

Is anybody aware how to update this character set through pl/sql ?

Not necessarily PL/SQL. You can do it with plain SQL. Michel already provided the solution. Here is some reading from docs, CONVERT

Report message to a moderator

Re: How to update character set of a excel sheet through pl/sql [message #599320 is a reply to message #599317]

Wed, 23 October 2013 11:36

Chinmay91
Messages: 15
Registered: July 2013
Location: Mumbai

Junior Member

Michel Russian characters are exists in our db and it's getting extracted successfully. Actually I don't want to convert the character, I just want the excel that getting extracted have to automatically change its character set to "UNICODE(UTF-8)" as I marked red in screenshot(in op).

Report message to a moderator

Re: How to update character set of a excel sheet through pl/sql [message #599322 is a reply to message #599320]

Wed, 23 October 2013 11:45

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

That it a tool. How could SQL or PL/SQL alter settings of an external tool?

Report message to a moderator

Re: How to update character set of a excel sheet through pl/sql [message #599324 is a reply to message #599320]

Wed, 23 October 2013 11:51

Solomon Yakobson
Messages: 3273
Registered: January 2010
Location: Connecticut, USA

Senior Member

And what this has to do with Oracle? Anyway, are you creating CSV in Oracle and then opening it in Excel? If so, CSV is just a text file. It has no notion of character set. What you could do is open excel, go to Data tab, click From Text (in Get External Data section) and select your file. Then Text Import Wizard page will let you choose "file origin".

SY.

Report message to a moderator

Re: How to update character set of a excel sheet through pl/sql [message #599325 is a reply to message #599324]

Wed, 23 October 2013 12:00

Chinmay91
Messages: 15
Registered: July 2013
Location: Mumbai

Junior Member

No SY, I am creating xls file..

Yes Lalit I was thinking to change alter setting for the extracted excel sheet automatically.

Report message to a moderator

Re: How to update character set of a excel sheet through pl/sql [message #599326 is a reply to message #599325]

Wed, 23 October 2013 12:03

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Chinmay91 wrote on Wed, 23 October 2013 22:30

Yes Lalit I was thinking to change alter setting for the extracted excel sheet automatically.

Chinmay, it's impossible.

Report message to a moderator

Re: How to update character set of a excel sheet through pl/sql [message #599327 is a reply to message #599325]

Wed, 23 October 2013 12:12

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Chinmay91 wrote on Wed, 23 October 2013 18:00

No SY, I am creating xls file..

How exactly are you creating an xls file?
You can't make a real xls with pl/sql.

Report message to a moderator

Re: How to update character set of a excel sheet through pl/sql [message #599328 is a reply to message #599325]

Wed, 23 October 2013 12:27

Solomon Yakobson
Messages: 3273
Registered: January 2010
Location: Connecticut, USA

Senior Member

Chinmay91 wrote on Wed, 23 October 2013 13:00

I am creating xls file..

Using what tool?

SY.

Report message to a moderator

Re: How to update character set of a excel sheet through pl/sql [message #599329 is a reply to message #599327]

Wed, 23 October 2013 12:37

Solomon Yakobson
Messages: 3273
Registered: January 2010
Location: Connecticut, USA

Senior Member

cookiemonster wrote on Wed, 23 October 2013 13:12

You can't make a real xls with pl/sql.

You can. There are several tools for this. For example, google Anton Scheffer's package.

SY.

Report message to a moderator

Re: How to update character set of a excel sheet through pl/sql [message #599332 is a reply to message #599320]

Wed, 23 October 2013 13:09

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Chinmay91 wrote on Wed, 23 October 2013 18:36

Michel Russian characters are exists in our db and it's getting extracted successfully. Actually I don't want to convert the character, I just want the excel that getting extracted have to automatically change its character set to "UNICODE(UTF-8)" as I marked red in screenshot(in op).

If this is not a SQL or PL/SQL issue why do you post it in a SQL forum?
As this has already been asked, how is this an Oracle issue? As far as I can see, you didn't answer to this question.

Report message to a moderator