[Koha-bugs] [Bug 9520] Update default LOC Z39.50 target

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9520

--- Comment #5 from Jonathan Druart <jonathan.druart at biblibre.com> ---
(In reply to comment #4)

> Sorry but.. did the comment applies to this bug?

Yes!

mysql> show create table z3950servers;
[...]
  `type` enum('zed','opensearch') NOT NULL DEFAULT 'zed',
[...]

mysql> UPDATE z3950servers SET host = 'lx2.loc.gov', port = 210, db = 'LCDB',
type = 'USMARC', encoding = 'utf8' WHERE name = 'LIBRARY OF CONGRESS';
Query OK, 0 rows affected, 1 warning (0.06 sec)
Rows matched: 1  Changed: 0  Warnings: 1

mysql> show warnings;
+---------+------+-------------------------------------------+
| Level   | Code | Message                                   |
+---------+------+-------------------------------------------+
| Warning | 1265 | Data truncated for column 'type' at row 4 |
+---------+------+-------------------------------------------+
1 row in set (0.00 sec)

mysql> select type from z3950servers where name='LIBRARY OF CONGRESS';
+------+
| type |
+------+
|      |
+------+
1 row in set (0.00 sec)

-- 
You are receiving this mail because:
You are watching all bug changes.