[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 --- Comment #8 from Tomás Cohen Arazi --- I made this bug dependent on 18336, because (as Mark correctly pointed out) the big problem for this is the DB handling this 4-byte characters (emojis, some japanese chars, etc). Changing the DB like this is important for other areas, not just tags. Luckily, I've submitted the patches to implement the change (on bug 18336). It will need to be broadly tested, so start now :-D I will leave this bug open, for the specific task of integrating an emoji picker for the tags adding form in the OPAC :-D -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 Tomás Cohen Arazi changed: What|Removed |Added Depends on||18336 Status|NEW |ASSIGNED Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18336 [Bug 18336] Use utf8mb4 instead of utf8 for MySQL tables, columns, and connections -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 Tomás Cohen Arazi changed: What|Removed |Added See Also|https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=18336 | -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 Tomás Cohen Arazi changed: What|Removed |Added Assignee|n...@bywatersolutions.com |tomasco...@gmail.com CC||tomasco...@gmail.com -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 Mason James changed: What|Removed |Added CC||m...@kohaaloha.com -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 David Cook changed: What|Removed |Added See Also||https://bugs.koha-community ||.org/bugzilla3/show_bug.cgi ||?id=18336 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 Nicole C. Engard changed: What|Removed |Added CC|neng...@gmail.com | -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 Nicole C. Engard changed: What|Removed |Added Change sponsored?|Sponsored |Seeking cosponsors -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 Nicole C. Engard changed: What|Removed |Added Change sponsored?|--- |Sponsored --- Comment #7 from Nicole C. Engard --- Work to be done: * Fix storage of Emoji characters in the database ** Emoji characters are supported in Unicode: http://www.unicode.org/emoji/charts/full-emoji-list.html * Research and implement tools to display Emojis properly in the Staff and OPAC Seeking co-sponsors: http://devs.bywatersolutions.com/projects/enable-emoji-support-tags/ -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 Owen Leonard changed: What|Removed |Added Assignee|oleon...@myacpl.org |n...@bywatersolutions.com Status|REOPENED|NEW -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 M. Tompsett changed: What|Removed |Added URL||http://devs.bywatersolution ||s.com/projects/enable-emoji ||-support-tags/ -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 --- Comment #6 from Katrin Fischer --- *** Bug 15885 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 Katrin Fischer changed: What|Removed |Added Status|RESOLVED|REOPENED CC||katrin.fisc...@bsz-bw.de Resolution|DUPLICATE |--- -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 Nicole C. Engard changed: What|Removed |Added Resolution|--- |DUPLICATE Status|NEW |RESOLVED CC||neng...@gmail.com --- Comment #5 from Nicole C. Engard --- *** This bug has been marked as a duplicate of bug 15885 *** -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 Jonathan Druart changed: What|Removed |Added CC||jonathan.dru...@bugs.koha-c ||ommunity.org See Also||https://bugs.koha-community ||.org/bugzilla3/show_bug.cgi ||?id=11944 --- Comment #4 from Jonathan Druart --- See bug 11944 comment 247 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 --- Comment #3 from M. Tompsett --- P.S. DataTables may not be as unicode friend as we would like for this. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 --- Comment #2 from M. Tompsett --- https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb4.html Hope these point in a useful direction. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794
M. Tompsett changed:
What|Removed |Added
CC||mtomp...@hotmail.com
--- Comment #1 from M. Tompsett ---
mysql> show variables like '%char%';
+--++
| Variable_name| Value |
+--++
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results| utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--++
8 rows in set (0.00 sec)
mysql> set character_set_database=utf8mb4;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_connection=utf8mb4;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_client=utf8mb4;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_results=utf8mb4;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like '%char%';
+--++
| Variable_name| Value |
+--++
| character_set_client | utf8mb4|
| character_set_connection | utf8mb4|
| character_set_database | utf8mb4|
| character_set_filesystem | binary |
| character_set_results| utf8mb4|
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--++
8 rows in set (0.00 sec)
mysql> drop database test_unicode;
Query OK, 1 row affected (0.01 sec)
mysql> CREATE DATABASE test_unicode DEFAULT CHARACTER SET utf8 DEFAULT COLLATE
utf8_general_ci;
Query OK, 1 row affected (0.00 sec)
mysql> use test_unicode;
Database changed
mysql> create table simple_table (text varchar(100)) collate utf8_unicode_ci;
Query OK, 0 rows affected (0.01 sec)
mysql> INSERT INTO simple_table VALUES ('💩');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> show warnings;
+-+--+---+
| Level | Code | Message
|
+-+--+---+
| Warning | 1366 | Incorrect string value: '\xF0\x9F\x92\xA9' for column 'text'
at row 1 |
+-+--+---+
1 row in set (0.00 sec)
mysql> delete from simple_table;
Query OK, 1 row affected (0.00 sec)
mysql> drop table simple_table;
Query OK, 0 rows affected (0.00 sec)
mysql> create table simple_table (text varchar(100)) collate
utf8mb4_unicode_ci;
Query OK, 0 rows affected (0.02 sec)
mysql> INSERT INTO simple_table VALUES ('💩');
Query OK, 1 row affected (0.01 sec)
mysql> select * from simple_table;
+--+
| text |
+--+
| 💩 |
+--+
1 row in set (0.00 sec)
mysql>
--
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 Marc Véron changed: What|Removed |Added CC||ve...@veron.ch -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 15794] Allow the use of emojis as tags on records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794 rhilli...@hotchkiss.org changed: What|Removed |Added CC||rhilli...@hotchkiss.org -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
