[Dspace-general] I can't see any item

[Héctor Garcia Peris]

The problem is when I try to create the database using UNICODE I get 
this error:

dspace at dspace:~$ /usr/lib/postgresql/8.3/bin/createdb -U dspace -E 
UNICODE dspace2
createdb: falló la creación de la base de datos:
ERROR:  la codificación UTF8 no coincide con la configuración regional 
del servidor es_ES
DETAIL:  La configuración regional LC_CTYPE del servidor requiere la 
codificación LATIN1.

Sorry, but the message is in Spanish. I try to translate it:

createdb: failed in the database creation
ERROR: UTF8 codification doesn't coincide with the regional 
configutation of the server es_ES
DETAIL: Regional codification LC_CTYPE of the server requires LATIN1 
codification.

This is the reason because my database is created with LATIN1. Any help 
to create it with UNICODE is welcome.

Thanks.

Hilton Gibson escribió:
> On Wednesday 09 September 2009 15:00:33 Héctor Garcia Peris wrote:
>   
>> I think the problem is related with the codification. If I create an
>> item with special characters like "Título 1", when I run this:
>>
>> dspace at dspace:~$ /home/dspace/dspace/bin/index-update
>> Creating browse index
>> Exception in thread "main" org.dspace.browse.BrowseException:
>> org.postgresql.util.PSQLException: ERROR: carácter 0xcc81 de
>> codificación «UTF8» no tiene equivalente en «LATIN1»
>> <lines suppressed>
>>
>> without special characters I have no problem.
>>
>> The problem is that I couldn't create the database if I don't use LATIN1
>> codification. How can I create the database with the UNICODE codification?
>>     
> See:
> http://services.lib.sun.ac.za/wiki/index.php/Install_Dspace_Server_Setup#Enable_Tomcat_with_UTF-8_multi-
> byte_encoding
>
> http://services.lib.sun.ac.za/wiki/index.php/Install_Dspace_Server_Setup#Create_the_PostgreSQL_.27dspace.27_database
>
> Cheers
>
> hg.
>
>   
>> Thanks.
>>
>> Claudia Jürgen escribió:
>>     
>>> Hola Héctor,
>>>
>>> did you ran
>>> [dspace]/bin/index-init after the fresh installation?
>>>
>>> Saludos
>>>
>>> Claudia Jürgen
>>>
>>> Héctor Garcia Peris schrieb:
>>>       
>>>> Hello,
>>>>
>>>> I have installed dspace 1.5.2 in a debian linux stable version.
>>>>
>>>> The installation uses postgres as database and is a new installation.
>>>> I have created a testing community and a testing collection without
>>>> problems. But when I have created a new item, although it was created
>>>> without problems I can't see it in the collection
>>>> (http://dspace:8080/jspui/handle/123456789/2) or when I try to find
>>>> it using the search engine
>>>> (http://dspace:8080/jspui/simple-search?query=&submit=Ir+).
>>>> Nevertheless I can access to the item data using the URI associated
>>>> to it (http://dspace:8080/jspui/handle/123456789/3).
>>>>
>>>> It seems that there is something missing between the collection and
>>>> the item. Can anybody help me?
>>>>
>>>> Thanks.
>>>>         
>
> _______________________________________________
> Dspace-general mailing list
> Dspace-general at mit.edu
> http://mailman.mit.edu/mailman/listinfo/dspace-general
>   

-- 

---------------------------------------------------------------------
Héctor Garcia Peris
Dpto. Informática
Instituto Valenciano de Investigaciones Económicas S.A. (Ivie) 
C/ Guardia Civil, 22 esc-2 1º 46020 - Valencia (Spain) 
Tfno.: +34 - 963190050 / +34 - 963930816 
Fax.: +34 - 963190055 / +34 - 963930856 
e-mail: hector.garcia at ivie.es 
Web: http://www.ivie.es
----------------------------------------------------------------------