Wrong default collation in where clausule for binary blob
---------------------------------------------------------
Key: CORE-3854
URL: http://tracker.firebirdsql.org/browse/CORE-3854
Project: Firebird Core
Issue Type: Bug
Components: API / Client Library, Charsets/Collation, Engine
Affects Versions: 2.5.1
Environment: Win32, Delphi, jvuib components
Reporter: Richard Stekly
Priority: Minor
database created with charset WIN1250, logged in with default charset WIN1250
table MY_TABLE - MY_FLD blob subtype 0;
working SQL: select * from MY_TABLE where MY_FLD starting with 'kůň'
wrong SQL: select * from MY_TABLE where MY_FLD starting with :MY_PARAM
PAS code:
IBSQL.Prepare;
IBSQL.Params[0].asString:='kůň';
IBSQL.ExecQuery;
in 250 returns matching records, in 251 returns nothing.
When token 'kůň' is changed to 'horse', it works fine.
Workaround is: select * from MY_TABLE where MY_FLD starting with cast(:MY_PARAM
as varchar(4096))
I mean it do'nt use charset from login for parameters or works with MY_PARAM
binary as-is.
--
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
