Hi All,
I am trying to do a case insensitive lookup on a varchar2(255) NOT Nullable column but am getting the following warning
Unrecognized Type specific format: {case-insensitve} on Key "COL_NM".
What could the reason be?
Case Insensitive Lookup Throwing a Warning
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Case Insensitive Lookup Throwing a Warning
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Case Insensitive Lookup Throwing a Warning
varchar2(255)
VS
varchar(255)
VS
varchar(255)
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Thanks for the reply. I did not create the schema manually. In fact, I am sourcing it from an Oracle table.
The actual lookup is being performed on two keys - one of which is this varchar column and the other is an integer. Could this be a problem though I don't see any reason for that.
The actual lookup is being performed on two keys - one of which is this varchar column and the other is an integer. Could this be a problem though I don't see any reason for that.
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Re: Case Insensitive Lookup Throwing a Warning
Sorry, I meant varchar(255)SURA wrote:varchar2(255)
VS
varchar(255)
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.