08.12.2017 13:56, Mark Rotteveel wrote: >> Because you are sending queries in connection charset. And string >> literals in them are >> in connection charset. Because of that your 'x' cannot have COLLATE >> PXW_HUNDC. > > I don't agree with this. The string literal is in the connection > character set, but the value should be converted to the target character > set (of the column) for the comparison, and that target character set > does know PXW_HUNDC. > > Right now, it looks like instead Firebird only tries to apply the target > collation, and not the target character set.
In the Firebird grammar, COLLATE has a higher priority than comparison operators. So it's parsed as "A CONTAINING (B COLLATE C)". B has charset UTF8 and collation C doesn't belong here. Dmitry ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
