[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6925) Unnecessary .toLowercase() in SQLServer2005 dialect

[Hasan Ceylan (JIRA)]

Unnecessary .toLowercase() in SQLServer2005 dialect
---------------------------------------------------

                 Key: HHH-6925
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6925
             Project: Hibernate Core
          Issue Type: Bug
          Components: core
    Affects Versions: 4.0.0.Final
         Environment: SQL Server with Turkish CI
            Reporter: Hasan Ceylan
            Priority: Blocker


in getLimitString(String, boolean), the original query is transformed to lower case. with non Turkish locale on the AS Server, this is lowered by latin rules. 

However, SQL Server as its locale is Turkish, cannot match TURKISH_TABLE / TURKISH_COLUMN with turkish_table / turkish_column raising "object / column not found" exception.

For detailed info on how 'I / i' handled in Turkish locale please refer to http://www.java2s.com/Tutorial/CSharp/0440__I18N-Internationalization/turkishiproblem.htm

Very simple fix is to remove the toLowerCase() from getLimitString(String, boolean). If that serves a purpose then lowering should be made based on SQL Server locale of the current user, connection, database (I am not sure). 

Regards,
Hasan Ceylan 

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira