Re: Retrieve case sensitive tables
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Tue, 08 Jan 2008 07:44:06 +0100
Message-ID: <5ugkdnF1d62lsU1@mid.individual.net>
>
> Hi Robert, I'm using ALL_TABLES but the .NET provider still changes
> the case.
>
> Created as: "my/table"
> From Oracle's shell: my/table
> From .NET: MY/TABLE
>
> Is there any way to specify that this shouldn't be the correct
> behavior?
Date: Tue, 08 Jan 2008 07:44:06 +0100
Message-ID: <5ugkdnF1d62lsU1@mid.individual.net>
On 07.01.2008 23:04, abbeyro_at_gmail.com wrote:
> On Jan 7, 1:26 pm, Robert Klemme <shortcut..._at_googlemail.com> wrote:
>> Adding to Ken's reply: there is also a slight chance that your .NET >> provider changes case, e.g. if you use some metadata facility. You >> could try to directly query USER_TABLES to see the table names.
>
> Hi Robert, I'm using ALL_TABLES but the .NET provider still changes
> the case.
>
> Created as: "my/table"
> From Oracle's shell: my/table
> From .NET: MY/TABLE
>
> Is there any way to specify that this shouldn't be the correct
> behavior?
I find this rather strange: normally any DB access layer has no business in changing the case of character data returned from the DB - at least not without explicitly telling it to do so. But you'll probably have better chances getting an answer to this by using a .NET specific forum. I would guess that someone else must have stumbled across this already because this would not only affect table names but other character data as well.
Kind regards
robert Received on Tue Jan 08 2008 - 00:44:06 CST