RE: [Firebird-devel] UPPER does not work with national characters

[Dmitry Y. <di...@us...>]

Balassa,

> Try this on a database with character set WIN1250:
> 
> SELECT 1 FROM rdb$database WHERE UPPER('abc') = UPPER('AbC')
> 
> The above query returns 1 as expected. Now, try it with 
> strings containing
> non-us characters (á, é, etc). The result is null.

Use appropriate collation explicitly, e.g.:

SELECT 1
FROM RDB$DATABASE
WHERE UPPER(<value1> COLLATE PXW_HUN) = UPPER(<value2> COLLATE PXW_HUN)

(for Hungarian language)


Dmitry