[ http://tracker.firebirdsql.org/browse/CORE-3928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Adriano dos Santos Fernandes reopened CORE-3928: ------------------------------------------------ I do not tested, but I know this is a important reason to reproduce this bug. > order select * from table where ci_ai_field collate UNICODE = 'c' is case > insensitive > ------------------------------------------------------------------------------------- > > Key: CORE-3928 > URL: http://tracker.firebirdsql.org/browse/CORE-3928 > Project: Firebird Core > Issue Type: Bug > Components: Charsets/Collation > Affects Versions: 2.5.1, 2.5.2 > Environment: Windows 7 64 bit > Reporter: Pablo León > Assignee: Adriano dos Santos Fernandes > > In a field with UNICODE_CI_AI collation, the following sentence is case > insensitive, witch IMHO is wrong behavior: > select * from table where ci_ai_field collate UNICODE = 'c' > furthermore, the following sentence is case sensitive (as expected): > select * from table where ci_ai_field collate UNICODE like 'c' -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://ad.doubleclick.net/clk;258768047;13503038;j? http://info.appdynamics.com/FreeJavaPerformanceDownload.html Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel