Package: cl-sql-mysql
Version: 3.1.2-1
Severity: important

When I try to get data from my MySQL server in SBCL 0.8.19, I receive
completely wrong text data.  For instance, I have the following table:

  mysql> create table foo (x varchar(100));
  Query OK, 0 rows affected (0.17 sec)

  mysql> insert into foo values ('lisp');
  Query OK, 1 row affected (0.03 sec)

  mysql> select * from foo;
  +------+
  | x    |
  +------+
  | lisp |
  +------+
  1 row in set (0.02 sec)

cl-sql returns the following data from the table:

  * (clsql:connect '("localhost" "enwiki" "" "") :database-type :mysql 
:if-exists :old)

  ; loading system definition from
  ; #P"/usr/share/common-lisp/systems/clsql-mysql.asd" into #<PACKAGE 
"ASDF10449">
  ; registering #<SYSTEM :CLSQL-MYSQL {9854CD1}> as CLSQL-MYSQL
  #<CLSQL-MYSQL:MYSQL-DATABASE localhost/enwiki/ OPEN {9A77269}>
  * (clsql:query "select * from foo")

  (("[EMAIL PROTECTED]@^@"))
  ("x")

I'm not sure in which SBCL version the problem occurred first, but IIRC
it was the first version with Unicode support.

-- System Information:
Debian Release: 3.1
  APT prefers testing
  APT policy: (989, 'testing'), (99, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.9
Locale: LANG=C, LC_CTYPE=cs_CZ.UTF-8 (charmap=UTF-8)

Versions of packages cl-sql-mysql depends on:
ii  cl-sql                        3.1.2-1    SQL Interface for Common Lisp
ii  cl-sql-uffi                   3.1.2-1    Common UFFI functions for CLSQL da
ii  libmysqlclient-dev            4.0.22-2   mysql database development files

-- no debconf information


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to