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

[Claudia Jürgen]

Hi Hector,

  -E UNICODE is the option to set the encoding for a new database.
See http://www.postgresql.org/docs/8.2/static/app-createdb.html for more 
details.
The command would be
createdb -U [databaseuser] -E UNICODE [databasename]
e.g.
createdb -U dspace -E UNICODE dspace
if both the dbuser and the dbname are dspace

If your db cluster got initialized with LATIN1 encoding (either 
explicitly by using -e or indirctly via the locales) a newly created db 
inherits the encoding unless otherwise specified, see:
http://www.postgresql.org/docs/8.2/static/app-initdb.html

Hope that helps

Claudia



Héctor Garcia Peris schrieb:
> 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?
> 
> 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.
>>>
>>>
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Claudia_Juergen.vcf
Type: text/x-vcard
Size: 372 bytes
Desc: not available
Url : http://mailman.mit.edu/pipermail/dspace-general/attachments/20090909/3e03d200/attachment.vcf