[Koha-devel] Problems with diacritics

Rodríguez, José L. jluis.rodriguez at patrimonionacional.es
Thu Sep 18 09:25:40 CEST 2008


Good morning,

I'm a new member in this list.

I,ve installed koha-3.00.00 and it works perfectly. But I have a problem with diacritics. In cataloguing, when I put a character whith diacritic mark (á, é ...) or the letter ñ, I get the next error

The following fatal error has occurred:

Can't call method "fields" on an undefined value at /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl line 193.

Apache	Server version: Apache/2.2.3 Server built: Jan 15 2008 20:33:41 	
Koha	3.00.00.107	
Koha DB	3.0000107	
MySQL	mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (x86_64) using readline 5.0 	
OS	Linux sanmillan.loading.es 2.6.18-028stab057.4 #1 SMP Fri Aug 1 10:47:59 MSD 2008 x86_64 x86_64 x86_64 GNU/Linux 	
Perl	5.008008	

The mysql, according to Joshua Ferraro  http://wiki.koha.org/doku.php?id=encodingscratchpad is correct:

mysql> show variables where variable_name LIKE "character_set%" OR  variable_name LIKE "collation%";
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
| collation_connection     | utf8_unicode_ci            |
| collation_database       | utf8_unicode_ci            |
| collation_server         | utf8_unicode_ci            |
+--------------------------+----------------------------+
11 rows in set (0.00 sec)

My question is: Which is the problem? Should I change the DBD::mysql configuration to enable utf-8?

Thanks in advance.

----------
José Luis Rodríguez
System Librarian
Real Biblioteca - Patrimonio Nacional
Palacio Real. C. Bailén, s.n. E28071 Madrid
Tel. +34 914548700 #7582 Fax +34 914548867
http://www.realbiblioteca.es



###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-devel/attachments/20080918/817a90a0/attachment-0002.htm>


More information about the Koha-devel mailing list