Your message dated Thu, 18 May 2023 22:48:29 +0000 with message-id <[email protected]> and subject line Bug#1028325: Removed package(s) from unstable has caused the Debian Bug report #721120, regarding libmyodbc: column names don't follow charset setting to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 721120: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=721120 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---Package: libmyodbc Version: 5.1.10-3 Severity: normal Bug originally hit in my role of LibreOffice/Base developer, treating issues connecting to MySQL over ODBC. The problem is that column names in result sets are *not* transcoded to the value of MyODBC's charset option, but (apparently) just copied byte-for-byte as what the MySQL server gives. Because MyODBC sets the server variable character_set_results to NULL, that is the value of character_set_system, which is usually (always?) utf8. Precise example: Make an entry in .odbc.ini like: [MySQL test] Driver = MySQL Server = localhost Database = test charset = latin1 (and create the test database in MySQL) Open a ISO8859-1 shell; for example: $ export LC_ALL=fr_LU # or any supported/enabled ISO8859-1 locale $ xterm ### switch to the new xterm $ isql 'MySQL test' user password SQL> CREATE TABLE élément ( numÉlément INT NOT NULL PRIMARY KEY ); SQL> SHOW TABLES; +-----------------------------------------------------------------+ | Tables_in_test | +-----------------------------------------------------------------+ | élément | +-----------------------------------------------------------------+ SQLRowCount returns 1 1 rows fetched SQL> SELECT * FROM élément; +-------------+ | numÃlément| +-------------+ +-------------+ SQLRowCount returns 0 SQL> SELECT numÉlément FROM élément; +-------------+ | numÃlément| +-------------+ +-------------+ SQLRowCount returns 0 SQL> SELECT numÉlément AS numéro_de_l_élément FROM élément; +-----------------------+ | numéro_de_l_élément| +-----------------------+ +-----------------------+ SQLRowCount returns 0 SQL> Note how: 1) The table name appears correctly in output of SHOW TABLES; (MyODBC presumably does the transcoding there) 2) The column name is parsed correctly from the SQL command 3) The column name appears wrongly in the result. (MyODBC should do transcoding, but does not. Or alternatively, MyODBC should set character_set_results to the value of its charset parameter, and not do any transcoding itself.) -- System Information: Debian Release: 7.1 APT prefers stable APT policy: (500, 'stable'), (400, 'testing'), (300, 'unstable'), (1, 'experimental') Architecture: amd64 (x86_64) Foreign Architectures: i386 Kernel: Linux 3.2.0-4-amd64 (SMP w/4 CPU cores) Locale: LANG=fr_LU.UTF-8, LC_CTYPE=fr_LU.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages libmyodbc:amd64 depends on: ii debconf [debconf-2.0] 1.5.49 ii libc6 2.17-92 ii libmysqlclient18 5.5.31+dfsg-0+wheezy1 ii odbcinst1debian2 2.2.14p2-5 ii zlib1g 1:1.2.7.dfsg-13 Versions of packages libmyodbc:amd64 recommends: ii libodbc1 2.2.14p2-5 libmyodbc:amd64 suggests no packages. -- debconf information: * libmyodbc/addtoodbc: true
--- End Message ---
--- Begin Message ---Version: 5.1.10-3+rm Dear submitter, as the package myodbc has just been removed from the Debian archive unstable we hereby close the associated bug reports. We are sorry that we couldn't deal with your issue properly. For details on the removal, please see https://bugs.debian.org/1028325 The version of this package that was in Debian prior to this removal can still be found using https://snapshot.debian.org/. Please note that the changes have been done on the master archive and will not propagate to any mirrors until the next dinstall run at the earliest. This message was generated automatically; if you believe that there is a problem with it please contact the archive administrators by mailing [email protected]. Debian distribution maintenance software pp. Scott Kitterman (the ftpmaster behind the curtain)
--- End Message ---
