in reply to Re: MariaDB : read credentials from file fails (via dsn option mariadb_read_default_file)
in thread MariaDB : read credentials from file fails (via dsn option mariadb_read_default_file)

No, it should work this way, too. But DBD::MariaDB fixed some bugs DBD::mysql had and wasn't able to fix. Especially given your interest in languages using non-ASCII characters, you might be interested in how UTF-8 handling is different in the two Perl drivers.

map{substr$_->[0],$_->[1]||0,1}[\*||{},3],[[]],[ref qr-1,-,-1],[{}],[sub{}^*ARGV,3]
  • Comment on Re^2: MariaDB : read credentials from file fails (via dsn option mariadb_read_default_file)
  • Download Code

Replies are listed 'Best First'.
Re^3: MariaDB : read credentials from file fails (via dsn option mariadb_read_default_file)
by Polyglot (Chaplain) on Nov 06, 2023 at 14:52 UTC
    For some years now I have been consistently creating my databases with the utf8mb4 charset. As long as the Perl script outputs to the DB in utf8 and reads from it in utf8, there have been no issues. How is the MariaDB improved over this?

    Blessings,

    ~Polyglot~

      You can use the testing script introduced in the issue #18 in DBD::ODBC. You need to comment out the drivers you don't have.

      map{substr$_->[0],$_->[1]||0,1}[\*||{},3],[[]],[ref qr-1,-,-1],[{}],[sub{}^*ARGV,3]