OraFAQ Forum: SQL & PL/SQL » Strange characters in Excel file

Home » SQL & PL/SQL » SQL & PL/SQL » Strange characters in Excel file (Oracle 10g)

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

Strange characters in Excel file [message #598852]

Fri, 18 October 2013 06:40

dev_777
Messages: 32
Registered: June 2010

Member

We have procedure that writes text to an Excel file.

The 10g database is setup for US7ASCII character set. This causes the characters on the Excel spreadsheet to appear strangely. As an example an 'a' would appear with a character similar to '~' on top of the 'a'.

If there anyway of resetting the chracter set at runtime of the procedure.

Report message to a moderator

Re: Strange characters in Excel file [message #598858 is a reply to message #598852]

Fri, 18 October 2013 07:39

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

Senior Member

dev_777 wrote on Fri, 18 October 2013 17:10

If there anyway of resetting the chracter set at runtime of the procedure.

No. It is done at system level.

Do you see the characeters properly in DB?

[Updated on: Fri, 18 October 2013 07:40]

Report message to a moderator

Re: Strange characters in Excel file [message #598860 is a reply to message #598852]

Fri, 18 October 2013 07:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> select ascii('a') from dual;

ASCII('A')
----------
        97

A far as I know the lower case 'a' is always value 97 in every character set.
Can you post any evidence that above is not true?

I strong suspect that are not accurately report reality in your problem statement.
The tilde-a character does not exist in US7ASCII character set.

Report message to a moderator

Re: Strange characters in Excel file [message #598870 is a reply to message #598860]

Fri, 18 October 2013 10:37

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

Senior Member
Account Moderator

Quote:

A far as I know the lower case 'a' is always value 97 in every character set.

This is correct.

Another explanation is that the character is really a ã but his Excel is not configured to show it and so convert it to a a...

[Edit: typo "?" instead of "."in first sentence]

[Updated on: Fri, 18 October 2013 10:42]

Report message to a moderator

Previous Topic:	Help with the SQL
Next Topic:	affected partition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 19:43:52 CDT 2024