February 15th, 2013, 04:28 AM
Join Date: Feb 2013
Time spent in forums: 8 m 25 sec
Reputation Power: 0
Uppercase with Umlaud (¨)
I'm having problem getting the correct result in my query; because the field I'm searching contains an Umlaud (¨)
This is what the query looks like.
WHERE (UPPER(FIELD1) LIKE = 'ZÜLZ')
Field1 contains 'Zülz', so in lower case.
Firebird 2.5; Charset WIN1252; and ANSI_CHARSET.
What I find odd is that if I query the following in firebird, I get the correct result ('ZÜLZ')
but, if I do
I get 'ZöLZ'; which is clearly wrong.
Can anyone shed a light on what's going wrong?