Hi, I have a problem with lower/upper functions. It seems that the lower function modifies some of the unicode characters(german, hungarian, romanian) and the upper case function modifies other(hindi).
When i say modifies i don't mean it transforms the the character in it's lower/upper form. It simply transforms some of the characters into mush(the charaters are distorted or transformed to "") To test this i used one special character on each record and used "SELECT x, LOWER(x), UPPER(x) FROM test_unicode" Anyhow... i attached the dump so you can test it yourself. What do you think is the problem? Thanks, xayk