Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Upper case - lower cases --> Problem Begins :(

Status
Not open for further replies.
Hattusas

Hattusas

Programmer
Nov 11, 2001
344
TR
I have a db2 7.1 database which is in 1254-TR code page.
When I use following SQL, national language characters(Ý,ý,þ) are wrongly converted
or interpreted so no result is returned. Expected result is "4,Micheal".

SELECT NO,NAME FROM EMP WHERE UPPER(NAME) LIKE 'MÝ%'
Data:
No Name
4 Micheal

Reference documents says I have to define "Collating Sequence", but how?
Or any other way to do that.
Thanks in advance.

Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr
 
Sort by date Sort by votes
Hi Salih,

From the SQL given I would expect no data to be returned. Your 'Ý' character is not an 'i' so I would expect it to not get picked up.

I'm obviously missing something here, so please get back to clarify.
Marc
 
Upvote 0 Downvote
<pre>Hi Marc thanks your reply.In Turkish alphabet the character representation is shown below.Left is the lower cases and the right is the upper.
Collating Sequence would be a solution.But how?Or any other solution?
Thanks in advance.</pre>
abc.gif



Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr
 
Upvote 0 Downvote
Hi Salih,
What's the operating system where your DB2 Db resides?
Marc
 
Upvote 0 Downvote
One system is Windows NT the other is Sun Solaris..Both of the codepage of DB2 database is 1254 (Turkish)

Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr
turkey_clr.gif
 
Upvote 0 Downvote
Salih,
Sorry but this is way outside of my scope of experience. I've had a search around on the net, and found some info on collating sequences and code pages (hence my question) as I wondered if you had the right code page. It appears to me that you have, and I'm not sure what to advise next. The only thing I will say is that when I looked up a couple of Turkish language alphabet pages, they didn't show the special national language characters that you are after. I'm wondering if these are additional to code page 1254.

It seems to me that you are wanting lower case 'i' to be translated to upcase 'Ý' which I don't think that code page will do as it will go to a large 'i'.

Sorry I can't help further.
Marc
 
Upvote 0 Downvote
Thanx for your attention on that subject.As soon as I find the solution I will inform you all the steps I performed.

Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr
turkey_clr.gif
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
250
mikrom
mikrom
cloudtwter
  • Locked
  • Question
CASE DATE
Replies
5
Views
152
cloudtwter
cloudtwter
Bigmag_imported
  • Locked
  • Question
UTF-8 --&gt; DB2 and diacritics.
Replies
0
Views
61
Bigmag_imported
Bigmag_imported
Rod41
  • Locked
  • Question
Problem on DB2 Update Table
Replies
6
Views
160
mikrom
mikrom
roopsingh
  • Locked
  • Question
Case statement in Group by clause in IBM DB2 LUW 10.1
Replies
6
Views
208
roopsingh
roopsingh

Part and Inventory Search

Sponsor

Back
Top