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. stdafx.h
          0.6 kB
        2. SQL-2.0.13.LOG
          5 kB
        3. SQL-1.0.6.LOG
          6 kB
        4. query_with_webmin.jpg
          query_with_webmin.jpg
          38 kB
        5. output-2.0.13.jpg
          output-2.0.13.jpg
          18 kB
        6. output-1.0.6.jpg
          output-1.0.6.jpg
          31 kB
        7. odbctest.cpp
          7 kB
        8. create_table_support.txt
          0.6 kB
        9. 004.jpg
          004.jpg
          82 kB
        10. 003.jpg
          003.jpg
          92 kB
        11. 002.jpg
          002.jpg
          90 kB
        12. 001.jpg
          001.jpg
          26 kB

        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.