Re: [firebird-support] Giving up UTF8

2019-03-30 Thread Luis Forra luis.fo...@gmail.com [firebird-support]
> > > 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] < > firebird-support@yahoogroups.com> escreveu no dia sábado, 30/03/2019 à(s) > 20:38: > > > > > > > > ISO8859_1 and WINPTBR are very similar in terms of symbols. Also, afair, > 8859 uses full dictionary sort. For portuguese, I alway

[firebird-support] Giving up UTF8

2019-03-30 Thread Luis Forra luis.fo...@gmail.com [firebird-support]
Hello all Because of CORE-5940 and CORE-5947 I can't use anymore the collation unicode_ci_ai, the greatest problems that I have is with the foreign keys, they are unusable with multiple varchar fields. I'm thinking of using WIN1252 with the collation WIN_PTBR but here is also ISO8859_1 with the c

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 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 ---

Re: [firebird-support] Re: Firebird 3.0.4 unicode_ci_ai index problems

2018-10-17 Thread Luis Forra luis.fo...@gmail.com [firebird-support]
hv...@users.sourceforge.net [firebird-support] < firebird-support@yahoogroups.com> escreveu no dia terça, 16/10/2018 à(s) 08:19: > > > ---In firebird-support@yahoogroups.com, wrote : > > > I found that if I add the a extra field in the index like the pk and > make the index unique it works fine.

Re: Fwd: [firebird-support] Re: Firebird 3.0.4 unicode_ci_ai index problems

2018-10-17 Thread Luis Forra luis.fo...@gmail.com [firebird-support]
nonomura nono181...@yahoo.co.jp [firebird-support] < firebird-support@yahoogroups.com> escreveu no dia terça, 16/10/2018 à(s) 15:14: > > > Analitico and all, > > I found that if I add the a extra field in the index like the pk and make > the index unique it works fine. > > > Many of those collati

Re: [firebird-support] Firebird 3.0.4 unicode_ci_ai index problems

2018-10-15 Thread Luis Forra luis.fo...@gmail.com [firebird-support]
is Forra luis.fo...@gmail.com [firebird-support] > wrote: > > What I'm doing wrong ? > >CI AI indexes are much bigger because of ICU implementation of index > key derivation. > You must increase page size of your database to return index de

Re: [firebird-support] Re: Firebird 3.0.4 unicode_ci_ai index problems

2018-10-15 Thread Luis Forra luis.fo...@gmail.com [firebird-support]
I found that if I add the a extra field in the index like the pk and make the index unique it works fine. Is expected to work fine even with the bug that you refer ? A segunda, 15/10/2018, 22:53, hv...@users.sourceforge.net [firebird-support] escreveu: > > > The problem is that multy-level co