Re: [Firebird-devel] FB 3.0 Replacing ICU libraries on Windows

2017-10-13 Thread Magnus Johansson
-Original Message- From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] Sent: Friday, October 13, 2017 6:42 PM To: firebird-devel@lists.sourceforge.net Subject: Re: [Firebird-devel] FB 3.0 Replacing ICU libraries on Windows >> > SQL> SELECT FIELD_UTF_SV_CI_NUM > CON> FROM  

Re: [Firebird-devel] FB 3.0 Replacing ICU libraries on Windows

2017-10-13 Thread Magnus Johansson
wrote: > 12.09.2017 15:33, Adriano dos Santos Fernandes wrote: >> On 12/09/2017 08:46, Magnus Johansson wrote: > ... >>>    SELECT FIELD_UTF_SV_CI_NUM >>> FROM   TABLE_T >>> WHERE  FIELD_UTF_SV_CI_NUM BETWEEN '' AND 'b' >>> ORDER BY 1; >>>

Re: [Firebird-devel] SEC$USERS and indices

2017-09-19 Thread Magnus Johansson
correct? > > If virtual table _could_ have indices - yes, that pair is unique. I see that I didn't express myself clearly, what I meant was that SEC$USER_NAME alone cannot be guaranteed unique if mixing different plugins, but I take it that's how you read it and answe

[Firebird-devel] SEC$USERS and indices

2017-09-18 Thread Magnus Johansson
that "security database" here can be any database I got uncertain. So being a Delphi guy only I probably miss the point but I have to ask probably stupid question with obvious answers. Regards, Magnus Johansson --

Re: [Firebird-devel] FB 3.0 Replacing ICU libraries on Windows

2017-09-12 Thread Magnus Johansson
what that means. However, I can't see any difference with my tests using it in either way. Adriano, thanks for your time on this. And judging by your comments I take it that the steps I had taken and described in how to replace the ICU libraries was correct and sufficient? Regards, Magnus Johanss

[Firebird-devel] Missing file-extensions in snapshot builds

2017-09-12 Thread Magnus Johansson
that when building the snapshot kits? Regards, Magnus Johansson -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web

[Firebird-devel] FB 3.0 Encryption

2012-10-29 Thread Magnus Johansson
Hi, On one of the sessions on the conference (nice to meet you all again) Vlad revisited encryption. Does I remember correctly that it is index, blob and data pages that is encrypted? And if so, does that also means that metadata is encrypted as well so that we don't have to set

Re: [Firebird-devel] FB 3: Use cases for updating system tablesdirectly

2011-11-30 Thread Magnus Johansson
Frank wrote: Using the API is one thing, but imho it should be possible to do all of that from within a SQL script - like DROP SOURCE OF [procedure name|trigger name|*] or CHANGE OWNER OF [db object|*] TO new_owner I like this. What about view name? Magnus