[Bug?] None English letters in variables upper vs lowercase

[Grovkillen]

I'm querying a database that got ÅÄÖåäö in some of the field names. If I use fields and have å ä or ö in the beginning of a field it will not work to do dynamic variable replacement.

I made this test and it confirms to me that in the case of these Nordic letters uppercase are not equal to lowercase:

Code: Select all

Let>Å=1
Let>Ä=2
Let>Ö=3

Let>TEMP=å
Let>TEMP=Å
Let>TEMP=ä
Let>TEMP=Ä
Let>TEMP=ö
Let>TEMP=Ö

Let>Xå=10
Let>Xä=20
Let>Xö=30

Let>TEMP=Xå
Let>TEMP=xå
Let>TEMP=XÅ
Let>TEMP=Xä
Let>TEMP=xä
Let>TEMP=XÄ
Let>TEMP=Xö
Let>TEMP=xö
Let>TEMP=XÖ

Let>TEMP=%xå%
Let>TEMP=%xä%
Let>TEMP=%xö%

Let>xx=123
Let>TEMP=xx
Let>TEMP=xX
Let>TEMP=XX
Let>TEMP=Xx

[PepsiHog]

@Grovkillen,
Just browsing for zero replies. The RegEx wizard that you are, is what made me curious. So RegEx can not solve this for you? You can't grab only [a-zA-Z0-9]?

What's the update on this venture? Is the computer still in one piece?

Share the knowledge, man.
PepsiHog

[Grovkillen]

I now use the uppercase command and that makes it work. But uppercase leaves the Nordic letters lowercase, so when comparing I need to make sure I use lowercase for those letters.