Recent content by iJimJ

Thank you-- I found it. The only non-language options that I tried were "General" and "General - Legacy" but I saw no differences in outcome. But then again, this is not a "New Database" as noted in the label for that option.

Thank you. All promising things to consider. There are no leading spaces however. I did not create this DB, I simply took it over. So I will need to figure out how to look inside at the properties for the field itself to see if there is something there that might impact on the encoding and the...

I am not sure where to look for what character set I am using, but I don't use any of the extended ASCII characters, only the first 128 characters. So UTF-8 should be identical to ASCII code order. It appears to me that Access has created its own non-ASCII character set encoding so that all...

This sounds promising. Where do I find the Option for Compare Binary so that I can switch between these options to see how they work. I couldn't find it in Options (I am using MS 365 and the title bar for the DB includes the phrase "Access 2007 - 2016 file format"). I was confused by your...

That does not appear to be the case. ASCII codes for {, }, | and ~ are higher than all alphanumeric and other special characters, therefore strings that begin with those characters should be at the end of an ascending sort. However, all strings that begin with any special character rise to the...

It does not sort in ASCII order! At least character strings are not sorted that way. I pasted a screen clip of my table that is sorted showing that "{" and "~" prefixed strings rise to the top, not the end, of my ascending order. I know there are solutions that involve additional fields as well...

I have a table and often sort it on the NAME field. The table includes records with Unknown and Erroneous names that I used to put square brackets around to keep them separate, but I would like all of these to be at the end of an ascending order. I don't want to insert ZZ prefixes to implement...

Hi all, I am a new member. I am a retired professor of computer science, with some info tech and web design background as well. But I lack deep understanding of MS Access since I never taught that course. So I am happy to join the forum since I manage an Access cemetery database and website. Jim