Hi Andras! well... I was sure (??) it wouldn't compile!! As a matter of fact
it was the first thing I tried! Obviously I had a typo somewhere and assumed
that the problem where with the "starting with" (and the typo wasn't "starts
with"... that was a mistake I did when I typed the question on
...?
if (str1 starts with str2) then...
thanks!!!
Sergio
__ Information from ESET Mail Security, version of virus signature
database 17768 (20180724) __
The message was checked by ESET Mail Security.
http://www.eset.com
[Non-text portions of this message have been removed]
Hello! I know that there are a lot of different ways to accomplish this, but I
wonder if I'm missing something...
if I want (inside a stored proc or a trigger) to know if str1 starts with
str2, I can do:
if (position(str2 in str1) = 1) then...
but there isn't something like the
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
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
13 matches
Mail list logo