Converting to Upper Case

[Natesan Prabhakaran]

Hi All,

when i try to convert the German character from Lower case to Upper case in SQL Query, it is not working.

I dont know, is it right place to ask this question. But i have very urgent issue. If anyone have idea, Please advise. Thanks.

Regards,
Prabhakaran.N

[Paul Sturrock]

when i try to convert the German character from Lower case to Upper case in SQL Query, it is not working

What is happening? Which character are you trying to convert?

[Christophe Verré]

If you're talking about the german esset (ß), I don't think there's any uppercase for it.

[Natesan Prabhakaran]

ä, ö, ü - These are the German characters, i can not conver from ä ö ü to Ö Ü Ä in SQL Query. In java we can chage the case. but for search engine, case sensitive made big problem.

[Ulf Dittmer]

I think it would help if you told us what exactly you're trying to do - post the SQL code you're executing that performs the conversion, and tell us in detail what happens when you execute it.

[Natesan Prabhakaran]

In Java - german esset (ß) - in converted to "SS" when we change the case. but in Query

select distinct(RESP_CTR), BRANCH_NAME from GTDFSEA.sebz_branch where AUTHORIZED_IND='A' and DELETED_FLG=0 and UPPER(BRANCH_NAME) like 'BALÜ%'

In this Query UPPER(BRANCH_NAME) is not working only for German Charcaters (ä ö ü ).

[Ulf Dittmer]

Strictly speaking, an uppercase of "ß" doesn't exist, so I'm not surprised that Java and SQL do different things when asked to perform the conversion. How about doing something like

LOWER(BRANCH_NAME) like 'balü%'

where the "balü" part is lowercased in the Java code?

[Natesan Prabhakaran]

yes. but In database BRANCH_NAME appears BALÜCARE, user enters balücase. so i am changing case to upper in java for user entered values. Also to successed the query, i am doing

UPPER(BRANCH_NAME)

This query not produce any result. English characters are converted to upper but the german character ü is not. This is applicable for both the convertions. Upper to Lower and Lower to Upper.

Regards,
Prabhakaran.N

[Jan Cumps]

In database BRANCH_NAME appears BALÜCARE, user enters balücase.

There is another mismatch. Upper case s will never match the _R_* in the second last position.



* note to JavaRanch. I tried to type a character RR (but then only one of them) here, but got this message:
The specific error message is: " r" is a silly English abbreviation; use "are" instead.

[Jeanne Boyarsky]

Jan,
Can you e-mail me the exact text you were trying to post that gave you the error. (My e-mail is in my profile if you click the link.)

Thanks,
Jeanne

[Campbell Ritchie]

The reason we blocked the single RR is because too many people were using text-message abbreviations.

[John Kimball]

Does your DBMS have a string/char replacement function, which you can nest?

If so, you can do something like the following:

...
WHERE LOWER(REPLACE(Ö, ö, REPLACE(Ü, ü, REPLACE(Ä, ä, BRANCH_NAME))like 'balü%' 

Otherwise, you'd have to account for every combination:

...
WHERE LOWER(BRANCH_NAME) like 'balü%'  
           OR LOWER(BRANCH_NAME) like 'balÜ%'