Re: [firebird-support] Strange behaviour on Linux

2017-12-07 Thread Hamish Moffatt ham...@risingsoftware.com [firebird-support]
On 08/12/17 04:48, dam...@wxs.nl [firebird-support] wrote: Hello, When I have the following directory structure on a Linux server: /a/b/c and I want to create a database /a/b/c/test.fdb with gbak, the access rights of directory "c" must be rwx (readable, writeable, executable). Also the

[firebird-support] Strange behaviour on Linux

2017-12-07 Thread Köditz, Martin martin.koed...@it-syn.de [firebird-support]
Hi Roy, the x flag is needed for file execution and directory access. While r says you can read the directory x says you can access it. Regards, Martin

Re: [firebird-support] Problem with CONTAINING and COLLATE

2017-12-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.12.2017 18:46, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: > Why does the connection charset count? Because you are sending queries in connection charset. And string literals in them are in connection charset. Because of that your 'x' cannot have COLLATE PXW_HUNDC. --

[firebird-support] Strange behaviour on Linux

2017-12-07 Thread dam...@wxs.nl [firebird-support]
Hello, When I have the following directory structure on a Linux server: /a/b/c and I want to create a database /a/b/c/test.fdb with gbak, the access rights of directory "c" must be rwx (readable, writeable, executable). Also the access rights to directory "a" and "b" must be r_x (readable,

[firebird-support] Problem with CONTAINING and COLLATE

2017-12-07 Thread Gabor Boros mlngl...@bgss.hu [firebird-support]
Hi All, I have a database with DEFAULT CHARACTER SET WIN1250 COLLATION PXW_HUN and a table in it: CREATE TABLE TABLE_1 (NEV VARCHAR(60) CHARACTER SET WIN1250 COLLATE PXW_HUN); Connect with ISQL: isql 1.2.3.4:MYDB -charset UTF8 -user myadmin -password mypasswd Execute this: SELECT * FROM

[firebird-support] Mapping

2017-12-07 Thread p62tpaxc3tdvxtc4d5si2g2...@yahoo.com [firebird-support]
I have a database which is its own security database. I now want users in the default security database to have access. So I created a mapping: create global mapping TrustedUsers using plugin Srp in "security.db" from any user to user This is based on the example the example in the