Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-88

Problem with ANSI character set in SELECT

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Not a Bug
    • 2.0.13
    • 2.0.13
    • None
    • None
    • Client: any Windows. Server: MariaDB version 10.0.28 on Fedora

    Description

      I have a small programm that runs fine with Maria ODBC 1.0.6. On entering some text it selects data from the server and displays it. With Maria ODBC 2.0.13 I do have a problem with special german characters (ö,ä,ü....).

      If the search string contains those characters nothing is found. You find the select in the 1st attached screenshot (was too lazy to write it down

      The problem seems to be only in the select. Cause the data returned (if you do a select without special chars) does contain those special chars and they are correctly shown in the program.

      The 2nd screenshot attached shows the situation with version 1.x of the ODBC connector. I searched for "mö" and got my results.

      The 3rd screenshot shows the situation with version 2.0.13. Same program, same Server. I also searched for "mö" but got no results.

      The 4th screenshot is also with version 2.0.13 but I searched for someting not containing "ö" to show that data containing "ö" is selected and normally displayed.

      The program itself doesn't use WCHAR. Just plain char which I think is ANSI (I'm no expert on character sets and still more and more confused the more I know about it

      I can just state that with no component changed but the ODBC connector there's a different behaviour.

      Attachments

        1. 001.jpg
          26 kB
          Sto Ges.m.b.H. Austria
        2. 002.jpg
          90 kB
          Sto Ges.m.b.H. Austria
        3. 003.jpg
          92 kB
          Sto Ges.m.b.H. Austria
        4. 004.jpg
          82 kB
          Sto Ges.m.b.H. Austria
        5. create_table_support.txt
          0.6 kB
          Sto Ges.m.b.H. Austria
        6. odbctest.cpp
          7 kB
          Sto Ges.m.b.H. Austria
        7. output-1.0.6.jpg
          31 kB
          Sto Ges.m.b.H. Austria
        8. output-2.0.13.jpg
          18 kB
          Sto Ges.m.b.H. Austria
        9. query_with_webmin.jpg
          38 kB
          Sto Ges.m.b.H. Austria
        10. SQL-1.0.6.LOG
          6 kB
          Sto Ges.m.b.H. Austria
        11. SQL-2.0.13.LOG
          5 kB
          Sto Ges.m.b.H. Austria
        12. stdafx.h
          0.6 kB
          Sto Ges.m.b.H. Austria

        Activity

          People

            Lawrin Lawrin Novitsky
            it.at.sto Sto Ges.m.b.H. Austria
            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.