Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

How to turn off ADO/Access Case Sensitive Field Names?

I developed an application using case insensitive field names VB/ADO/Jet4.  When I switch to another regional setting, example Turkey, my Field Titles become case sensitive!  I tried to use the Locale Setting (1033-general) in the connect string, but that doesnt work.


Is there any way to turn this Field Title case sensitivity off so that my program can run without many field name changes?

Thanks for any help, Greg
0
GregBrady
Asked:
GregBrady
1 Solution
 
supunrCommented:
not sure if this is going to help, but when you doing comparisons convert all string fields to upper/lower.

e.g.

if (lcase(rsRec.Fields("FieldName").value) = lcase(txtField.text)) then '...

' Good Luck!
0
 
dmstratCommented:
I know you've probably thought of this and it may not be the answer you are wanting to hear, but one of reasons that Oracle doesn't have this issue is because all columns are CAPITALIZED... I would suggest doing this if possible so you wouldn't have to worry about the case issue quickly.

Not sure on the other problem why specifying region specific but it could be because of the language itself.  

But hope this "suggestion" helps.
0
 
GregBradyAuthor Commented:
Well,  The program is written in locale 1033, the database was created in locale 1033.  It's just the ADO or OLE layer that is switching the way it is interpreting database information.  I am looking for a way to force locale interpretation.

Thanks, Greg
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
GregBradyAuthor Commented:
Problem Resolution:

The 'i' character in Turkey is case sensitive.  Making sure that all table/column references with words with an 'i' character match chase delt with the problem.

See microsoft article:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;279651

Thanks for your help, Greg


0
 
CleanupPingCommented:
Hi GregBrady,
This old question (QID 20565590) needs to be finalized -- accept an answer, split points, or get a refund.  Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.
0
 
GPrentice00Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

 -->PAQ - with points refunded

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER

GPrentice00
Cleanup Volunteer
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now