Re: [firebird-support] [CHARSET] Different result whitn FB3 and FB25
Thank you Second option is what I did finally and it works perfect
Re: [firebird-support] [CHARSET] Different result whitn FB3 and FB25
On 24-7-2018 16:46, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 24.07.2018 14:31, eric.gueguin...@gmail.com [firebird-support] wrote: >> By example how to do that : >> >> SELECT IDSYSCONFGROUP FROM SYS_CONF_GROUP >> WHERE UPPER(CAST(SYSGROUP_NAME AS VARCHAR(100) CHARACTER SET ISO8859_1) >> COLLATE >> FR_FR_CI_AI) = 'CAMERA' >> >> SYSGROUP_NAME can be written like this : caméra, camera,camèra,camêra .. > > First of all try to remove UPPER and put collate clause into CAST. Make > sure that your > connection charset is ISO8859_1, so string literal is recognized right. The collate clause is not supported within CAST (which is an interesting omission). It should be sufficient - assuming SYSGROUP_NAME already is ISO8859_1 - to use SYSGROUP_NAME collate FR_FR_CI_AI = 'CAMERA' Otherwise CAST(SYSGROUP_NAME AS VARCHAR(100) CHARACTER SET ISO8859_1) COLLATE FR_FR_CI_AI = 'CAMERA' -- Mark Rotteveel
Re: [firebird-support] [CHARSET] Different result whitn FB3 and FB25
Thank you Dimitry ! Now it works as I wanted ;)
Re: [firebird-support] [CHARSET] Different result whitn FB3 and FB25
24.07.2018 14:31, eric.gueguin...@gmail.com [firebird-support] wrote: > By example how to do that : > > SELECT IDSYSCONFGROUP FROM SYS_CONF_GROUP > WHERE UPPER(CAST(SYSGROUP_NAME AS VARCHAR(100) CHARACTER SET ISO8859_1) > COLLATE > FR_FR_CI_AI) = 'CAMERA' > > SYSGROUP_NAME can be written like this : caméra, camera,camèra,camêra .. First of all try to remove UPPER and put collate clause into CAST. Make sure that your connection charset is ISO8859_1, so string literal is recognized right. -- WBR, SD.
Re: [firebird-support] [CHARSET] Different result whitn FB3 and FB25
By example how to do that : SELECT IDSYSCONFGROUP FROM SYS_CONF_GROUP WHERE UPPER(CAST(SYSGROUP_NAME AS VARCHAR(100) CHARACTER SET ISO8859_1) COLLATE FR_FR_CI_AI) = 'CAMERA' SYSGROUP_NAME can be written like this : caméra, camera,camèra,camêra .. Other case, I load all country's name in a memory dataSet and the function locate is not accent insensitive, so my users would have all country name in upper case without acccent to do search
Re: [firebird-support] [CHARSET] Different result whitn FB3 and FB25
24.07.2018 13:46, eric.gueguin...@gmail.com [firebird-support] wrote: > In fact I wanted the result of FB25 (without accents) > It is possible to remove accents by using charset with FB3 in the select > clause ? No. But why do you want that? Accent-insensitive comparison and sort is working with CI collations. -- WBR, SD. ++ 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/
Re: [firebird-support] [CHARSET] Different result whitn FB3 and FB25
Thank you Dimitry, In fact I wanted the result of FB25 (without accents) It is possible to remove accents by using charset with FB3 in the select clause ? Thank you Eric
Re: [firebird-support] [CHARSET] Different result whitn FB3 and FB25
24.07.2018 9:42, eric.gueguin...@gmail.com [firebird-support] wrote: > Could you explain why the result of this queryis not the same with FB3 and > FB25 ? Because Firebird 2.5 has i18n module mostly broken. -- WBR, SD. ++ 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/
[firebird-support] [CHARSET] Different result whitn FB3 and FB25
Hello, My Database CHARSET is WIN1252 Ex : SELECT UPPER(CAST('caméra' AS VARCHAR(100) CHARACTER SET ISO8859_1) COLLATE FR_FR)from RDB$DATABASE FB25 => CAMERA FB3 => CAMÉRA Could you explain why the result of this query is not the same with FB3 and FB25 ? I used this query to remove accent, but with FB3 it seems to not work like this (I tried with COLLATE FR_FR_CI_AI, but same result) Thank you Eric