Database with accents and diacritics

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

cbarbal
Posts: 114
Joined: Fri May 08, 2015 5:04 pm

Database with accents and diacritics

Post by cbarbal » Thu Sep 27, 2018 11:53 am

Hi,

I would like to know if there is someone who uses a database in which accented words or diacritics are stored. They look good in LiveCode and you can search for these types of words and find them. I've been spending about three weeks on it, not wanting to lose time from now, if it's not possible to get what I need.

Looking over the Internet most of the solutions are having duplicate text fields. One with the accents and the other without the accents and do the search for the latter. It does not work for me

There is a solution that works for me, but I want to leave FileMaker and I have to use it as a database to change it. With the new version of FileMaker the minimum number of licenses is 5 and you also have the server. The server is no longer sold individually, a FileMakerPro Advanced license costs 696.96 € VAT incl. I could make it serve as a server, no problem activating ODBC and JDBC, but I find it expensive to use it only as a server.

I know I'm a bit heavy with the theme of accents and diacritics, I'm not lucky enough to use a language that does not use them. And I have to be very clear to continue with LiveCode

If someone has been able to solve it and wants to share it?

Regards,

Carles

ghettocottage
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 366
Joined: Tue Apr 10, 2012 9:18 am

Re: Database with accents and diacritics

Post by ghettocottage » Thu Sep 27, 2018 2:38 pm

Can you post a list of the different accented words or diacritics you are speaking of...perhaps a list of fake names and such that are similar to what you would use?

I am working on a database right now and can check to see if they give me any problems.

cbarbal
Posts: 114
Joined: Fri May 08, 2015 5:04 pm

Re: Database with accents and diacritics

Post by cbarbal » Thu Sep 27, 2018 3:18 pm

Here you have the relationship. You can see all the possible combinations from 7 to 10.

Barça
Mañana
Càrles
Pingüino
Ramón
Sofía
àèìòù
áéíóú
ÀÈÌÒÙ
ÁÉÍÓÚ
çñ
ÇÑ

Thanks for your answer

ghettocottage
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 366
Joined: Tue Apr 10, 2012 9:18 am

Re: Database with accents and diacritics

Post by ghettocottage » Thu Sep 27, 2018 3:51 pm

I was able to post and search with no problems.

I am using Livecode Community Edition 9 for the front-end, and a remote server with MariaDB, Apache2, anbd Livecode Community Edition Server 9.

I url-encode everything before sending it to my remote server. I did not have to make any changes to my existing code to get your special characters to work. I just typed them in and they sent to the database with no issues.

Image

cbarbal
Posts: 114
Joined: Fri May 08, 2015 5:04 pm

Re: Database with accents and diacritics

Post by cbarbal » Thu Sep 27, 2018 4:58 pm

Hi ghettocottage

There would be some way to know the type of character and collation of the server, I suppose that with PhpMyAdmin you can see how this database is defined?

I have XAMPP, locally, with MariaDB and I have not managed to find the right combination. Will not Livecode Community Edition Server 9 have anything to do with it?

Thank you very much for your interest

Carles

cbarbal
Posts: 114
Joined: Fri May 08, 2015 5:04 pm

Re: Database with accents and diacritics

Post by cbarbal » Thu Sep 27, 2018 5:05 pm

Hi ghettocottage,

I have a previous post with my experiment with MariaDB viewtopic.php?f=12&t=31516

ghettocottage
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 366
Joined: Tue Apr 10, 2012 9:18 am

Re: Database with accents and diacritics

Post by ghettocottage » Thu Sep 27, 2018 7:38 pm

From the phpMyAdmin Charsets of my server:


Collation Description
  • armscii8 (ARMSCII-8 Armenian)
    armscii8_bin Armenian, Binary
    armscii8_general_ci Armenian, case-insensitive
    ascii (US ASCII)
    ascii_bin West European (multilingual), Binary
    ascii_general_ci West European (multilingual), case-insensitive
    big5 (Big5 Traditional Chinese)
    big5_bin Traditional Chinese, Binary
    big5_chinese_ci Traditional Chinese, case-insensitive
    binary (Binary pseudo charset)
    binary Binary
    cp1250 (Windows Central European)
    cp1250_bin Central European (multilingual), Binary
    cp1250_croatian_ci Croatian, case-insensitive
    cp1250_czech_cs Czech, case-sensitive
    cp1250_general_ci Central European (multilingual), case-insensitive
    cp1250_polish_ci Polish, case-insensitive
    cp1251 (Windows Cyrillic)
    cp1251_bin Cyrillic (multilingual), Binary
    cp1251_bulgarian_ci Bulgarian, case-insensitive
    cp1251_general_ci Cyrillic (multilingual), case-insensitive
    cp1251_general_cs Cyrillic (multilingual), case-sensitive
    cp1251_ukrainian_ci Ukrainian, case-insensitive
    cp1256 (Windows Arabic)
    cp1256_bin Arabic, Binary
    cp1256_general_ci Arabic, case-insensitive
    cp1257 (Windows Baltic)
    cp1257_bin Baltic (multilingual), Binary
    cp1257_general_ci Baltic (multilingual), case-insensitive
    cp1257_lithuanian_ci Lithuanian, case-insensitive
    cp850 (DOS West European)
    cp850_bin West European (multilingual), Binary
    cp850_general_ci West European (multilingual), case-insensitive
    cp852 (DOS Central European)
    cp852_bin Central European (multilingual), Binary
    cp852_general_ci Central European (multilingual), case-insensitive
    cp866 (DOS Russian)
    cp866_bin Russian, Binary
    cp866_general_ci Russian, case-insensitive
    cp932 (SJIS for Windows Japanese)
    cp932_bin Japanese, Binary
    cp932_japanese_ci Japanese, case-insensitive
    dec8 (DEC West European)
    dec8_bin West European (multilingual), Binary
    dec8_swedish_ci Swedish, case-insensitive
    eucjpms (UJIS for Windows Japanese)
    eucjpms_bin Japanese, Binary
    eucjpms_japanese_ci Japanese, case-insensitive
    euckr (EUC-KR Korean)
    euckr_bin Korean, Binary
    euckr_korean_ci Korean, case-insensitive
    gb2312 (GB2312 Simplified Chinese)
    gb2312_bin Simplified Chinese, Binary
    gb2312_chinese_ci Simplified Chinese, case-insensitive
    gbk (GBK Simplified Chinese)
    gbk_bin Simplified Chinese, Binary
    gbk_chinese_ci Simplified Chinese, case-insensitive
    geostd8 (GEOSTD8 Georgian)
    geostd8_bin Georgian, Binary
    geostd8_general_ci Georgian, case-insensitive
    greek (ISO 8859-7 Greek)
    greek_bin Greek, Binary
    greek_general_ci Greek, case-insensitive
    hebrew (ISO 8859-8 Hebrew)
    hebrew_bin Hebrew, Binary
    hebrew_general_ci Hebrew, case-insensitive
    hp8 (HP West European)
    hp8_bin West European (multilingual), Binary
    hp8_english_ci English, case-insensitive
    keybcs2 (DOS Kamenicky Czech-Slovak)
    keybcs2_bin Czech-Slovak, Binary
    keybcs2_general_ci Czech-Slovak, case-insensitive
    koi8r (KOI8-R Relcom Russian)
    koi8r_bin Russian, Binary
    koi8r_general_ci Russian, case-insensitive
    koi8u (KOI8-U Ukrainian)
    koi8u_bin Ukrainian, Binary
    koi8u_general_ci Ukrainian, case-insensitive
    latin1 (cp1252 West European)
    latin1_bin West European (multilingual), Binary
    latin1_danish_ci Danish, case-insensitive
    latin1_general_ci West European (multilingual), case-insensitive
    latin1_general_cs West European (multilingual), case-sensitive
    latin1_german1_ci German (dictionary), case-insensitive
    latin1_german2_ci German (phone book), case-insensitive
    latin1_spanish_ci Spanish, case-insensitive
    latin1_swedish_ci Swedish, case-insensitive
    latin2 (ISO 8859-2 Central European)
    latin2_bin Central European (multilingual), Binary
    latin2_croatian_ci Croatian, case-insensitive
    latin2_czech_cs Czech, case-sensitive
    latin2_general_ci Central European (multilingual), case-insensitive
    latin2_hungarian_ci Hungarian, case-insensitive
    latin5 (ISO 8859-9 Turkish)
    latin5_bin Turkish, Binary
    latin5_turkish_ci Turkish, case-insensitive
    latin7 (ISO 8859-13 Baltic)
    latin7_bin Baltic (multilingual), Binary
    latin7_estonian_cs Estonian, case-sensitive
    latin7_general_ci Baltic (multilingual), case-insensitive
    latin7_general_cs Baltic (multilingual), case-sensitive
    macce (Mac Central European)
    macce_bin Central European (multilingual), Binary
    macce_general_ci Central European (multilingual), case-insensitive
    macroman (Mac West European)
    macroman_bin West European (multilingual), Binary
    macroman_general_ci West European (multilingual), case-insensitive
    sjis (Shift-JIS Japanese)
    sjis_bin Japanese, Binary
    sjis_japanese_ci Japanese, case-insensitive
    swe7 (7bit Swedish)
    swe7_bin Swedish, Binary
    swe7_swedish_ci Swedish, case-insensitive
    tis620 (TIS620 Thai)
    tis620_bin Thai, Binary
    tis620_thai_ci Thai, case-insensitive
    ucs2 (UCS-2 Unicode)
    ucs2_bin Unicode (multilingual), Binary
    ucs2_croatian_ci Croatian, case-insensitive
    ucs2_croatian_mysql561_ci Croatian
    ucs2_czech_ci Czech, case-insensitive
    ucs2_danish_ci Danish, case-insensitive
    ucs2_esperanto_ci Esperanto, case-insensitive
    ucs2_estonian_ci Estonian, case-insensitive
    ucs2_general_ci Unicode (multilingual), case-insensitive
    ucs2_general_mysql500_ci Unicode (multilingual)
    ucs2_german2_ci German (phone book), case-insensitive
    ucs2_hungarian_ci Hungarian, case-insensitive
    ucs2_icelandic_ci Icelandic, case-insensitive
    ucs2_latvian_ci Latvian, case-insensitive
    ucs2_lithuanian_ci Lithuanian, case-insensitive
    ucs2_myanmar_ci unknown, case-insensitive
    ucs2_persian_ci Persian, case-insensitive
    ucs2_polish_ci Polish, case-insensitive
    ucs2_roman_ci West European, case-insensitive
    ucs2_romanian_ci Romanian, case-insensitive
    ucs2_sinhala_ci Sinhalese, case-insensitive
    ucs2_slovak_ci Slovak, case-insensitive
    ucs2_slovenian_ci Slovenian, case-insensitive
    ucs2_spanish2_ci Traditional Spanish, case-insensitive
    ucs2_spanish_ci Spanish, case-insensitive
    ucs2_swedish_ci Swedish, case-insensitive
    ucs2_thai_520_w2 Thai
    ucs2_turkish_ci Turkish, case-insensitive
    ucs2_unicode_520_ci Unicode (multilingual)
    ucs2_unicode_ci Unicode (multilingual), case-insensitive
    ucs2_vietnamese_ci Vietnamese, case-insensitive
    ujis (EUC-JP Japanese)
    ujis_bin Japanese, Binary
    ujis_japanese_ci Japanese, case-insensitive
    utf16 (UTF-16 Unicode)
    utf16_bin unknown, Binary
    utf16_croatian_ci Croatian, case-insensitive
    utf16_croatian_mysql561_ci Croatian
    utf16_czech_ci Czech, case-insensitive
    utf16_danish_ci Danish, case-insensitive
    utf16_esperanto_ci Esperanto, case-insensitive
    utf16_estonian_ci Estonian, case-insensitive
    utf16_general_ci unknown, case-insensitive
    utf16_german2_ci German (phone book), case-insensitive
    utf16_hungarian_ci Hungarian, case-insensitive
    utf16_icelandic_ci Icelandic, case-insensitive
    utf16_latvian_ci Latvian, case-insensitive
    utf16_lithuanian_ci Lithuanian, case-insensitive
    utf16_myanmar_ci unknown, case-insensitive
    utf16_persian_ci Persian, case-insensitive
    utf16_polish_ci Polish, case-insensitive
    utf16_roman_ci West European, case-insensitive
    utf16_romanian_ci Romanian, case-insensitive
    utf16_sinhala_ci Sinhalese, case-insensitive
    utf16_slovak_ci Slovak, case-insensitive
    utf16_slovenian_ci Slovenian, case-insensitive
    utf16_spanish2_ci Traditional Spanish, case-insensitive
    utf16_spanish_ci Spanish, case-insensitive
    utf16_swedish_ci Swedish, case-insensitive
    utf16_thai_520_w2 Thai
    utf16_turkish_ci Turkish, case-insensitive
    utf16_unicode_520_ci Unicode (multilingual)
    utf16_unicode_ci Unicode (multilingual), case-insensitive
    utf16_vietnamese_ci Vietnamese, case-insensitive
    utf16le (UTF-16LE Unicode)
    utf16le_bin unknown, Binary
    utf16le_general_ci unknown, case-insensitive
    utf32 (UTF-32 Unicode)
    utf32_bin unknown, Binary
    utf32_croatian_ci Croatian, case-insensitive
    utf32_croatian_mysql561_ci Croatian
    utf32_czech_ci Czech, case-insensitive
    utf32_danish_ci Danish, case-insensitive
    utf32_esperanto_ci Esperanto, case-insensitive
    utf32_estonian_ci Estonian, case-insensitive
    utf32_general_ci unknown, case-insensitive
    utf32_german2_ci German (phone book), case-insensitive
    utf32_hungarian_ci Hungarian, case-insensitive
    utf32_icelandic_ci Icelandic, case-insensitive
    utf32_latvian_ci Latvian, case-insensitive
    utf32_lithuanian_ci Lithuanian, case-insensitive
    utf32_myanmar_ci unknown, case-insensitive
    utf32_persian_ci Persian, case-insensitive
    utf32_polish_ci Polish, case-insensitive
    utf32_roman_ci West European, case-insensitive
    utf32_romanian_ci Romanian, case-insensitive
    utf32_sinhala_ci Sinhalese, case-insensitive
    utf32_slovak_ci Slovak, case-insensitive
    utf32_slovenian_ci Slovenian, case-insensitive
    utf32_spanish2_ci Traditional Spanish, case-insensitive
    utf32_spanish_ci Spanish, case-insensitive
    utf32_swedish_ci Swedish, case-insensitive
    utf32_thai_520_w2 Thai
    utf32_turkish_ci Turkish, case-insensitive
    utf32_unicode_520_ci Unicode (multilingual)
    utf32_unicode_ci Unicode (multilingual), case-insensitive
    utf32_vietnamese_ci Vietnamese, case-insensitive
    utf8 (UTF-8 Unicode)
    utf8_bin Unicode (multilingual), Binary
    utf8_croatian_ci Croatian, case-insensitive
    utf8_croatian_mysql561_ci Croatian
    utf8_czech_ci Czech, case-insensitive
    utf8_danish_ci Danish, case-insensitive
    utf8_esperanto_ci Esperanto, case-insensitive
    utf8_estonian_ci Estonian, case-insensitive
    utf8_general_ci Unicode (multilingual), case-insensitive
    utf8_general_mysql500_ci Unicode (multilingual)
    utf8_german2_ci German (phone book), case-insensitive
    utf8_hungarian_ci Hungarian, case-insensitive
    utf8_icelandic_ci Icelandic, case-insensitive
    utf8_latvian_ci Latvian, case-insensitive
    utf8_lithuanian_ci Lithuanian, case-insensitive
    utf8_myanmar_ci unknown, case-insensitive
    utf8_persian_ci Persian, case-insensitive
    utf8_polish_ci Polish, case-insensitive
    utf8_roman_ci West European, case-insensitive
    utf8_romanian_ci Romanian, case-insensitive
    utf8_sinhala_ci Sinhalese, case-insensitive
    utf8_slovak_ci Slovak, case-insensitive
    utf8_slovenian_ci Slovenian, case-insensitive
    utf8_spanish2_ci Traditional Spanish, case-insensitive
    utf8_spanish_ci Spanish, case-insensitive
    utf8_swedish_ci Swedish, case-insensitive
    utf8_thai_520_w2 Thai
    utf8_turkish_ci Turkish, case-insensitive
    utf8_unicode_520_ci Unicode (multilingual)
    utf8_unicode_ci Unicode (multilingual), case-insensitive
    utf8_vietnamese_ci Vietnamese, case-insensitive
    utf8mb4 (UTF-8 Unicode)
    utf8mb4_bin Unicode (multilingual), Binary
    utf8mb4_croatian_ci Croatian, case-insensitive
    utf8mb4_croatian_mysql561_ci Croatian
    utf8mb4_czech_ci Czech, case-insensitive
    utf8mb4_danish_ci Danish, case-insensitive
    utf8mb4_esperanto_ci Esperanto, case-insensitive
    utf8mb4_estonian_ci Estonian, case-insensitive
    utf8mb4_general_ci Unicode (multilingual), case-insensitive
    utf8mb4_german2_ci German (phone book), case-insensitive
    utf8mb4_hungarian_ci Hungarian, case-insensitive
    utf8mb4_icelandic_ci Icelandic, case-insensitive
    utf8mb4_latvian_ci Latvian, case-insensitive
    utf8mb4_lithuanian_ci Lithuanian, case-insensitive
    utf8mb4_myanmar_ci unknown, case-insensitive
    utf8mb4_persian_ci Persian, case-insensitive
    utf8mb4_polish_ci Polish, case-insensitive
    utf8mb4_roman_ci West European, case-insensitive
    utf8mb4_romanian_ci Romanian, case-insensitive
    utf8mb4_sinhala_ci Sinhalese, case-insensitive
    utf8mb4_slovak_ci Slovak, case-insensitive
    utf8mb4_slovenian_ci Slovenian, case-insensitive
    utf8mb4_spanish2_ci Traditional Spanish, case-insensitive
    utf8mb4_spanish_ci Spanish, case-insensitive
    utf8mb4_swedish_ci Swedish, case-insensitive
    utf8mb4_thai_520_w2 Thai
    utf8mb4_turkish_ci Turkish, case-insensitive
    utf8mb4_unicode_520_ci Unicode (multilingual)
    utf8mb4_unicode_ci Unicode (multilingual), case-insensitive
    utf8mb4_vietnamese_ci Vietnamese, case-insensitive
Open new phpMyAdmin window

cbarbal
Posts: 114
Joined: Fri May 08, 2015 5:04 pm

Re: Database with accents and diacritics

Post by cbarbal » Thu Sep 27, 2018 8:06 pm

Hi,

I'm sorry I have not explained myself well. I mean, how do you have your database set up? Something like that

Character: latin1_spanish_ci collate: utf8_spanish_ci

ghettocottage
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 366
Joined: Tue Apr 10, 2012 9:18 am

Re: Database with accents and diacritics

Post by ghettocottage » Thu Sep 27, 2018 9:20 pm

Database server

Server: Localhost via UNIX socket
Server type: MariaDB
Server version: 10.1.34-MariaDB-0ubuntu0.18.04.1 - Ubuntu 18.04
Protocol version: 10
User: the_admin@localhost
Server charset: UTF-8 Unicode (utf8)
Server connection collation: utf8mb4_unicode_ci

Web server

Apache/2.4.29 (Ubuntu)
Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
PHP version: 7.2.10-0ubuntu0.18.04.1

cbarbal
Posts: 114
Joined: Fri May 08, 2015 5:04 pm

Re: Database with accents and diacritics

Post by cbarbal » Fri Sep 28, 2018 10:06 am

Configuring the database on the server:
Safari001.jpg
Safari001.jpg (11.36 KiB) Viewed 11374 times
Original text:
Càrlès Bàrbal Gonçälves
áéíóú çñ ÑÇ
Without textEncode:
LiveCode001.jpg
With textEncode, disappear accented vowels and diacritics:
LiveCode002.jpg

Servidor: Localhost via UNIX socket:
Tipo de servidor: MariaDB
Conexión del servidor: No se está utilizando SSL Documentación
Versión del servidor: 10.1.35-MariaDB - Source distribution
Versión del protocolo: 10
Usuario: root@localhost
Conjunto de caracteres del servidor: UTF-8 Unicode (utf8)

Servidor web:
Apache/2.4.34 (Unix) OpenSSL/1.0.2p PHP/7.2.9 mod_perl/2.0.8-dev Perl/v5.16.3
Versión del cliente de base de datos: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $
extensión PHP: mysqliDocumentación curlDocumentación mbstringDocumentación
Versión de PHP: 7.2.9

There are differences in the version of MariaDB, PHP and Apache. But I think that they should not affect.

I do not know what to think. Yesterday I saw the video of Global LiveCode
Learn to Code: Couch DB and REST API with Greg (Mr. Pink) Miller
. I'm going to do the last tests, if this does not work for me, I'll have to leave it.

Thanks for your time gettocottage

Carles

ghettocottage
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 366
Joined: Tue Apr 10, 2012 9:18 am

Re: Database with accents and diacritics

Post by ghettocottage » Fri Sep 28, 2018 2:18 pm

what happens if you use phpMyadmin to enter the same data into the database? Are the results the same? ..or are you only getting those results when you use Livecode to send data to the database?

cbarbal
Posts: 114
Joined: Fri May 08, 2015 5:04 pm

Re: Database with accents and diacritics

Post by cbarbal » Fri Sep 28, 2018 2:37 pm

The data I enter directly with PhpMyAdmin, I leave from the base that the client can already have his data and open that show it. I will test the other way, this afternoon or tomorrow

cbarbal
Posts: 114
Joined: Fri May 08, 2015 5:04 pm

Re: Database with accents and diacritics

Post by cbarbal » Fri Sep 28, 2018 7:47 pm

Without textEncode
Cˆrls Bˆrbal GonŠlves ‡Ž’—œ – „‚

With textEncode
Càrlès Bàrbal Gonçälves áéíóú çñ ÑÇ

Original text in LiveCode
Càrlès Bàrbal Gonçälves áéíóú çñ ÑÇ

It does not work for me, it's time to return to the origins.

Thanks for everything

Carles

cbarbal
Posts: 114
Joined: Fri May 08, 2015 5:04 pm

Re: Database with accents and diacritics

Post by cbarbal » Sat Sep 29, 2018 10:39 am

Solved!. Replica of a post on stackoverflow.com by Anthony Taylor https://stackoverflow.com/users/1770210/anthony-taylor
Turns out MariaDB has a bug which turns the database formating to latin1 intead of utf8

To correct for this you must go to /etc/my.cnf remove all instances of

default-character-set=utf8
find title "mysqld" in my.cnf and put under it

init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
and save.

Then restart mariadb.

Anthony Taylor
The problems with the accents and the searches were finished, checked. I will continue deepening with LiveCode.

Thank you ghettocottage, without your answers I would not have gotten it,

Carles

capellan
Posts: 654
Joined: Wed Aug 15, 2007 11:09 pm

Re: Database with accents and diacritics

Post by capellan » Sat Sep 29, 2018 9:11 pm

Hi Carles,

Looks like this MariaDB configuration file has many copies
Did you modify each copy or only one?

If you modified only one configuration file, then
Which one?
MariaDB 10.0.12

Location Scope

/etc/my.cnf Global
/etc/mysql/my.cnf Global
SYSCONFDIR/my.cnf Global
$MYSQL_HOME/my.cnf Server
defaults-extra-file File specified with --defaults-extra-file=path, if any
~/.my.cnf User
MariaDB starting with 10.0.13

When SYSCONFDIR is not defined (for example, in binary tarballs and DEB packages)

Location Scope
/etc/my.cnf Global
/etc/mysql/my.cnf Global
$MYSQL_HOME/my.cnf Server
defaults-extra-file File specified with --defaults-extra-file=path, if any
~/.my.cnf User

When SYSCONFDIR is defined (for example, in RPM packages it is /etc)

Location Scope
SYSCONFDIR/my.cnf Global
$MYSQL_HOME/my.cnf Server
defaults-extra-file File specified with --defaults-extra-file=path, if any
~/.my.cnf User
This is the original link for this list:
https://mariadb.com/kb/en/library/confi ... ith-mycnf/

Al

Post Reply

Return to “Databases”