In the last blog dated april 24, 2008 http://techsouls.blogspot.com/2008/04/turkish-capital-i-i-with-dot-is-without.html, I wrote about the Turkish ı/İ problem and solution with MSSQL DB. Same problem on oracle DB is solved in a little different way. Take a look at the following statement.
NLS_UPPER(NAME, 'NLS_SORT=XTURKISH') like UPPER('iword%', NLS_SORT=XTURKISH')
Solution is to use NLS_UPPER for oracle DB, oracle has provided this api which works just fine provided that a sorting order is provided (XTURKISH in above case).
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment