|
View previous topic :: View next topic
|
| Author |
Message |
Kumar shobhit
New User
Joined: 29 May 2007
Posts: 14
Location: bangalore
|
|
|
|
Hi All,
I have data in UTF-16 format soted in table . its is having some special characters(non english) . i have to implement upper case translation logic in sql query, that should translate both english as well as non enlish character to their upper case equivalent. i tried using the function upper-
select upper (<feild name>) from table.
the problem with the apporach is that it convert only english character, but non english character remain unchanged.
The data base iam using is DB2 V8 (ENFM) . and the its on Z/os( mainframe) system.
Could any suggest me how to implement, its urgent |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
If it is urgent, i suggest that you forego this
| Quote: |
| i have to implement upper case translation logic in sql query |
non-business restriction.
Why can the process not read the rows, do whatever translation is needed and then update the rows if any change(s) were made?
Just a thought. . . |
|
| Back to top |
|
|
|
|
