SQL Question

Hello,


Access 2010 run under Windows 8.1

I have a table with a memo field called "DescriptionLogg". In this memofield I store the word "tataaaa" which does not mean anything but was just for testing.

I tried coincidentally to find the record with a query (SQL in code or with the querybuilder) by searching on:
descriptionlogg like "*tata*" -> result = 0 record
descriptionlogg like "*tataa*" -> result = 1 record
descriptionlogg like "*tataaa*" -> result = 0 record
descriptionlogg like "*tataaaa*" -> result = 1 record

Not trying to lose my faith in SQL I tried it with a different random word
"teteeee" (which does not mean anything either)
descriptionlogg like "*tete*" -> result = 1 record
descriptionlogg like "*tetee*" -> result = 1 record
descriptionlogg like "*teteee*" -> result = 1 record
descriptionlogg like "*teteeee*" -> result = 1 record

Who knows why this difference occurs?

Thanks

Ben

Try it in a text field.

Uncle Gizmo said:

Try it in a text field.

Click to expand...

Hello,

Thank you for your quick reply.
I am sorry, but I need a memo field and trying to understand why this does not work.

Norwegian alphabet is probably the culprit. The sql is confused about when an aa is one letter (å), and when it is a literal aa. If you tell it to use English then the confusion will go away, presumably.

Read about database sort order and how to change it here http://www.fmsinc.com/TPapers/intaa/index.html

Brilliant!!!!!!! It is not visible that this happens, but I am convinced

That somebody from outside Norway must tell me that it is (again) the language which works against me ;-)