-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: lowercase conversion creates problematic SQL with Turkish
PostPosted: Thu Apr 08, 2004 9:15 am 
Newbie

Joined: Thu Apr 08, 2004 8:46 am
Posts: 11
Location: Istanbul
Hi,
New to Hibernate, Have a feeling like it's the next big thing after Java in the database.
Problem is:
Trying to run the auction example. When trying to run "view all auction items" query the following SQL is constructed and MySQL rejects this as it contains a Turkish character (ı) For those who cannot see this character correctly, it is an "i" without a dot. In Turkish there are two different letters as "i" and "i-no-dot". Uppercase conversion of these are "I-dot" and "I" respectively
That is if you convert an "I" to lowercase in Turkish, it is not "i" but a suspect character of "i-no-dot" in English alphabet. This is rejected by MySQL.
I ran the following without a problem in console after removing the "i-no-dot" at the "action(i)te0" correlation name.
What could I do?
Regards,
Levent Aksu

select auctionıte0_.id as id0_, bids1_.id as id1_, user2_.id as id2_, auctionıte0_.description as descript2_0_, auctionıte0_.ends as ends0_, auctionıte0_.condition as condition0_, auctionıte0_.seller as seller0_, auctionıte0_.successfulBid as successf6_0_, bids1_.isBuyNow as isBuyNow1_, bids1_.amount as amount1_, bids1_.datetime as datetime1_, bids1_.bidder as bidder1_, bids1_.item as item1_, user2_.userName as userName2_, user2_.`password` as y3_2_, user2_.email as email2_, user2_.firstName as firstName2_, user2_.`initial` as y6_2_, user2_.lastName as lastName2_, bids1_.id as id__, bids1_.item as item__ from auctionitem auctionıte0_ left outer join bid bids1_ on auctionıte0_.id=bids1_.item left outer join auctionuser user2_ on bids1_.bidder=user2_.id order by auctionıte0_.ends desc limit ?


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.