 | |
Retrieve case sensitive tables
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: Retrieve case sensitive tables -
01-07-2008
, 04:04 PM
|
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. |
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?
Thanks.
#12
| |||
| |||
|
|
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. |
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?
Thanks.
#13
| |||
| |||
|
|
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. |
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?
Thanks.
#14
| |||
| |||
|
|
On Jan 7, 1:26 pm, Robert Klemme <shortcut... (AT) googlemail (DOT) 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? |
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
#15
| |||
| |||
|
|
On Jan 7, 1:26 pm, Robert Klemme <shortcut... (AT) googlemail (DOT) 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? |
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
#16
| |||
| |||
|
|
On Jan 7, 1:26 pm, Robert Klemme <shortcut... (AT) googlemail (DOT) 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? |
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
#17
| |||
| |||
|
|
On Jan 7, 1:26 pm, Robert Klemme <shortcut... (AT) googlemail (DOT) 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? |
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
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.