UNICODE_CI_AI: SELECT
---------------------
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
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
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
