Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15387

setting section collation charset

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Not a Bug
    • 5.5.59-galera
    • N/A
    • Character Sets
    • None
    • Windows, delphi application

    Description

      I'm actually developping an application using delphi as a programming laguage and mariaDB as a database server, i generate a query with the application witch creates variables in the connection session and affecte to them values, my problem accours when try to compare the value of a variable and a database field i have the message: illegal mix of collations (utf8_general_ci implicit) and (utf8_unicode_ci implicit) but whene i try to execute the same query in a database administration tool (heidiSQL) it runs normally.
      Example of query : set @code_employe = '000';
      set @nbr_enf_en_charge := (select valeur from employe_info_libre where code_info_libre = 'Question1' and code_employe = @code_employe) ;
      select @nbr_enf_en_charge as nbr_enf_en_charge ;
      And i think that is the collation used for the encoding of the variables values and i want to set it to utf8_unicode_ci. Thank you

      Attachments

        Activity

          People

            Unassigned Unassigned
            AmineItachi Amine Kouicem
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.