Re: [firebird-support] Firebird 3.0.4 Ubuntu 18.04.1 64bits ICU problems

2018-12-03 Thread Luis Forra luis.fo...@gmail.com [firebird-support]
Rustam rusta...@ukr.net [firebird-support] escreveu no dia segunda, 3/12/2018 à(s) 13:47: > > > > Try 'backup' your DB on working machine/OS, then 'restore' from *.fbk on problematic server. Thank you, it worked

[firebird-support] Firebird 3.0.4 Ubuntu 18.04.1 64bits ICU problems

2018-12-03 Thread Rustam rusta...@ukr.net [firebird-support]
Try 'backup' your DB on working machine/OS, then 'restore' from *.fbk on problematic server. 03 грудня 2018, 15:30:02, від "Luis Forra luis.fo...@gmail.com [firebird-support]" :   I cant use UTF8 databases in 18.04.1 LTS, I instaled libicu-dev the error in firebird.log is  crescer Mon Dec 

[firebird-support] Firebird 3.0.4 Ubuntu 18.04.1 64bits ICU problems

2018-12-03 Thread Luis Forra luis.fo...@gmail.com [firebird-support]
I cant use UTF8 databases in 18.04.1 LTS, I instaled libicu-dev the error in firebird.log is crescer Mon Dec 3 12:56:11 2018 initUnicodeCollation failed - UnicodeUtil::Utf16Collation::create failed Any ideias ? Thank you Luis Forra ---

[firebird-support] substring similar - "Invalid SIMILAR TO pattern"

2018-12-03 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi,   Firebird 3   can someone tell me how to work with substring similar?   SELECT substring('abc' similar 'a' escape '#')  FROM RDB$DATABASE raise an error "Invalid SIMILAR TO pattern"     SELECT substring('ab11c' similar '[0-9]+' escape '#')  FROM RDB$DATABASE raise an error "Invalid SIMILAR TO