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:dsp...@dspace:~$ /home/dspace/dspace/bin/index-update Creating browse indexException 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.
<<attachment: Claudia_Juergen.vcf>>
_______________________________________________ Dspace-general mailing list [email protected] http://mailman.mit.edu/mailman/listinfo/dspace-general
