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

--- Comment #5 from Jonathan Druart <[email protected]> ---
(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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to