
February 15th, 2013, 03:28 AM
|
|
Registered User
|
|
Join Date: Feb 2013
Posts: 1
Time spent in forums: 8 m 25 sec
Reputation Power: 0
|
|
|
Uppercase with Umlaud (¨)
Hello,
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.
SELECT FIELD1
FROM TABLE1
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')
SELECT UPPER('Zölz')
FROM RDB$DATABASE
but, if I do
SELECT UPPER(FIELD1)
FROM TABLE1
I get 'ZöLZ'; which is clearly wrong.
Can anyone shed a light on what's going wrong?
Thank you!
|