Thank you
Second option is what I did finally and it works perfect
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)
Thank you Dimitry !
Now it works as I wanted ;)
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
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
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
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
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.
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