Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Character changing when inserting into Oracle

979621Dec 12 2012 — edited Dec 15 2012
I am debugging an old web service which is using Enterprise Services. The service is sitting in IIS 6 using .NET 4. A new problem appeared when an insert statement was generated that attempted to insert a string which included a degree symbol. When executed, the degree symbol is changed to an upside down question mark. No error messages were generated.

The strange thing is that I took a copy of the assemblies and dropped them on a test machine (same OS and IIS) and the insert statement worked. I've been trying to find the difference between the two machines to determine why this is happening. It's the same code running so I know the code is not the issue. I also know that it's using the same Microsoft Oracle provider. I've examined the region/language settings and the config files in the core framework folders and everything matches.

Anyone have any idea what I'm missing or where I can look for additional settings?

Additional information:

NLS_CHARACTERSET - WE8ISO8859P1
NLS_LANGUAGE - AMERICAN
NLS_TERRITORY - AMERICA
NLS_CALENDAR - GREGORIAN
NLS_DATE_FORMAT - DD-MON-RR
NLS_DATE_LANGUAGE - AMERICAN
NLS_SORT - BINARY
NLS_TIME_FORMAT - HH.MI.SSXFF AM
This is the connection string from the object: OleDbConnection("Provider=MSDAORA.1;...

And the oracle client installed is version 10.

Comments

Anthony Rayner-Oracle

Hi,
Thanks for reporting this. I was able to reproduce it and have filed bug #32808045.
I'm afraid the only workaround I can offer (and something that it looks like you've tried already yourself on the test page), is to switch to using the 'Popup LOV', and set 'Search as you type' for a somewhat similar user experience.
Hope that helps,
Anthony

Leon_M

@anthony-rayner-oracle
Thank you for your suggestion. Unfortunately we can't use Popup LOV either as it has another issue in Interactive grid.
The issue was reported here:
https://community.oracle.com/tech/developers/discussion/4340268/apex-20-1-popup-lov-in-interactive-grid-causing-issue/p1?new=1
The bug #31689248 was opened for this issue. Unfortunately the bug was not resolved in Apex 21.1 release.
Hopefully the bug #32808045 that you filed will be resolved soon.
We prefer to use Autocomplete as it is already implemented in our Apps.
Thanks again,
Leon

Anthony Rayner-Oracle

Hi Leon,
I'm sorry about this, and also the blocking bug with regards using Popup LOV, I was not aware of that.
I have raised the severity of the autocomplete bug, so it will be prioritised for the next release. I'm sorry I can't give you a better answer than this today. I've also made a note of this thread in the bug, so we can provide any updates here.
Regards,
Anthony

fzdev

I am using text field with auto complete on oracle cloud service.
my list is from a table containing 90k rows. Chrome seems to hang when trying to autocomplete.
is there anything I can do to prevent the page busy error in chrome?

RobDavis

Is there any progress on solving bug #31689248 or bug #32808045? Is either still open? This is still an issue in 21.2

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 12 2013
Added on Dec 12 2012
9 comments
6,153 views