#559: BibUpload: Cannot bibupload file containing UTF-8 chars
------------------------+------------------
Reporter: grfavre | Owner:
Type: defect | Status: new
Priority: critical | Milestone: v1.0
Component: BibUpload | Version:
Resolution: | Keywords:
------------------------+------------------
Comment (by grfavre):
Hi Tibor,
{{{
(infoscience-env)kis@kissrv49:~$ inveniocfg --detect-system-details
>>> Going to detect system details...
* Hostname: kissrv49
* Invenio version: 1.0.0-rc0
* Python version: 2.6.6 (r266:84292, Dec 26 2010, 22:31:48) [GCC 4.4.5]
* Apache version: Apache/2.2.16 (Debian) [/usr/sbin/apache2]
* MySQLdb version: 1.2.2
* MySQL version:
- version: 5.1.49-3
- character_set_client: utf8
- character_set_connection: utf8
- character_set_database: utf8
- character_set_results: utf8
- character_set_server: utf8
- character_set_system: utf8
- collation_connection: utf8_general_ci
- collation_database: utf8_general_ci
- collation_server: utf8_general_ci
>>> System details detected successfully.
}}}
The records were dumped as xml and rebibuploaded/reindexed last april
(after database was utf8ized; it should be OK then.
After verification of a single record it seems OK:
{{{
mysql> select * from bib24x where id = 237;
+-----+--------+-----------------------------------------------------------------------------------------------------------------+
| id | tag | value
|
+-----+--------+-----------------------------------------------------------------------------------------------------------------+
| 237 | 245__a | Oxymoron, un tr?sor de fiches de lecture et un atelier de
mutualisation des savoirs entre apprenants/chercheurs |
+-----+--------+-----------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> set names utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from bib24x where id = 237;
+-----+--------+------------------------------------------------------------------------------------------------------------------+
| id | tag | value
|
+-----+--------+------------------------------------------------------------------------------------------------------------------+
| 237 | 245__a | Oxymoron, un trésor de fiches de lecture et un atelier de
mutualisation des savoirs entre apprenants/chercheurs |
+-----+--------+------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
}}}
--
Ticket URL: <http://invenio-software.org/ticket/559#comment:7>
Invenio <http://invenio-software.org>
