- discuss - lists.mariadb.org

[Maria-discuss] Collations, trailing spaces and unique indexes
by Binarus 21 Mar '16

21 Mar '16

Dear all, I already have done some MySQL development and now eventually would like to switch to MariaDB because I no longer can stand the following: "All MySQL collations are of type PADSPACE. This means that all CHAR, VARCHAR, and TEXT values in MySQL are compared without regard to any trailing spaces. “Comparison” in this context does not include the LIKE pattern-matching operator, for which trailing spaces are significant." "For those cases where trailing pad characters are stripped or comparisons ignore them, if a column has an index that requires unique values, inserting into the column values that differ only in number of trailing pad characters will result in a duplicate-key error. For example, if a table contains 'a', an attempt to store 'a ' causes a duplicate-key error." (taken from https://dev.mysql.com/doc/refman/5.5/en/char.html) I did not find any information whether the collations which MariaDB provides are of type PADSPACE as in MySQL (none of the collation tables from MariaDB's documentation does contain this information) or not. To make a long story short: I would like to have CHAR and VARCHAR fields with unique indexes which consider 'a' and 'a ' to be different values (which is the only reasonable point of view IMHO). This is not possible with MySQL. Is it possible with MariaDB? I am generally working with charset UTF8 and would be happy with a general solution, but also with a non-general solution which only works with UTF8. Since the index behaviour obviously depends on the collation, would building an own collation which does not PADSPACE be an option? I have read vague hints about that in MariaDB's documentation, but didn't try yet (before doing so, I would like to know if there is an easy, clean solution). Thank you very much for any ideas, Binarus

10 27

[Maria-discuss] New Question: netframework support
by AskMonty KB 21 Mar '16

21 Mar '16

Hello, A new question has been asked in "MariaDB Documentation" by juantoledo. Please answer it at http://mariadb.com/kb/en/netframework-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Do you plan to support connection for apps with Microsoft net framework? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/netframework-support/

1 0

[Maria-discuss] warning : bison executable not found in PATH
by Shubham Barai 18 Mar '16

18 Mar '16

Hello everyone, I was trying to build MariaDB from source on windows. I have already installed bison in the dir C:\GnuWin32\ but still I am getting this error bison executable not found in PATH Any help would be appreciated. Thanks, Shubham

2 1

[Maria-discuss] MariaDB CONNECT Storage Engine access to Oracle 11GR2
by Ghazi Btissam 16 Mar '16

16 Mar '16

Hi, I saw an article about the equivalent of the Oracle DbLink feature in MariaDb, I found that the connect engine with the ODBC table type can do an insert+select on an Oracle remote table ,but the *update *of the remote data is it possible? Thanks

2 1

[Maria-discuss] New Question: MariaDB Connector for Windows (1.05)
by AskMonty KB 15 Mar '16

15 Mar '16

Hello, A new question has been asked in "MariaDB Connector/ODBC" by fred_taylor_g. Please answer it at http://mariadb.com/kb/en/mariadb-connector-for-windows-105/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to connect to a MariaDB 10 database using the MariaDB ODBC Connector 1.05 on a WIN7 32 bit machine, but I can't get connected using it as I get an "Connectivity Error: Unknown system variable 'max_allowed_packet_size'". I can create a DSN and the "test" says it works, but I get the same error trying to use that DSN from Visual FoxPro 9.0/SP2. It fails with the above error trying a connection string in VFP: SQLSTRINGCONNECT("Driver={MariaDB ODBC 1.0 Driver};Server=localhost;UID=myuser;PWD=mypwd;DB=test;Port=3306;") Any explanations,as I can't find anything on 'max_allowed_packet_size'? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-connector-for-windows-105/

1 0

[Maria-discuss] Partitionning question
by Ghazi Btissam 14 Mar '16

14 Mar '16

Hi, 1- Could a partitioned table contain, or be referenced by, foreign keys? 2- As I saw in MariaDb documentation ,the subpartitions may use either HASH or KEY partitioning. Does the LIST subpartitioning exists in MariaDb? Can we use : a composite partitionning : RANGE/LIST? Thanks

2 1

[Maria-discuss] New Question: How do I install the ODBC connector/driver on Linux Mint 17.3
by AskMonty KB 13 Mar '16

13 Mar '16

Hello, A new question has been asked in "MariaDB Connector/ODBC" by Redman Companies. Please answer it at http://mariadb.com/kb/en/how-do-i-install-the-odbc-connectordriver-on-linux… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I can not find the installation procedure for the gzip or source packages anywhere. (1.0.5 or 2.0.9) Thanks in advance. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-do-i-install-the-odbc-connectordriver-on-linux…

1 0

[Maria-discuss] AUTO_INCREMENT and partitioning
by Ghazi Btissam 12 Mar '16

12 Mar '16

Hi, 1- I have a table with a unique key which is calculated by the AUTO_INCREMENT feature, and I need to range partition it using a date field , is it possible and/or how to do it? 2- Is there a way to implement sequences for the primary key (like it exists in Oracle) or the AUTO_INCREMENT is the only one in MariaDb? For example: CREATE TABLE new ( id INT NOT NULL AUTO_INCREMENT, name VARCHAR(50), added DATE, PRIMARY KEY (id), ) PARTITION BY RANGE( TO_DAYS(added) ) ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS THAN (2000), PARTITION p2 VALUES LESS THAN MAXVALUE ) ; Thanks

3 3

[Maria-discuss] Read/Write file
by Ghazi Btissam 12 Mar '16

12 Mar '16

Hi, How to read/write a text file from a MariaDb routine ? Is this possible only via tables (loading via Load data infile or using connect engine..)? Thanks

3 2

[Maria-discuss] MariaDB CONNECT Storage Engine access to Oracle 11GR2
by Ghazi Btissam 12 Mar '16

12 Mar '16

Hi, I saw an article about the equivalent of the Oracle DbLink feature in MariaDb, I found that the connect engine with the ODBC table type can do an insert+select on an Oracle remote table ,but the update of the remote data is it possible? Thanks

1 0