Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Case Sensitive

Status
Not open for further replies.
IrishLassie

IrishLassie

Technical User
Mar 25, 2009
22
CA
When I use the finder in Accpac for account name, vendor name etc. it is case sensitive. It is only like this in one of my companies - It is because of the way it was originally set up or can I change this?

Thanks
 
Sort by date Sort by votes
It was how it was set up, the SQL collation order is probably binary.

You might be able to fix it with a Dbdump/Dbload, but if you have IC units of measure like "EACH", "each", and "Each", it will take data surgery to fix.
 
Upvote 0 Downvote
It's easy to test:

1. Create a new empty company in MSSQL with case insensitive collation order
2. Dbdump the old
3. Dbload into the new
4. If you get a "127" error, it means you have duplicate keys. If you don't, you're fine.

 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top