Hi Hector,<br><br>I'm not the most technical person in our team, but after googling I found following topic that might be of help.<br><br>here's the link:<a href="http://www.forosdelweb.com/f99/postgresql-8-3-0-no-deja-crear-bd-con-encoding-latin1-559822/"><br>
http://www.forosdelweb.com/f99/postgresql-8-3-0-no-deja-crear-bd-con-encoding-latin1-559822/</a><br><br>Here's what you do (according to the discussion):<br><br><b>1) Te "logeas" como root.<br><br>
2) Deten el postgres según tu distribución (si está activo). <br>
rcpostgresql stop<br>
/etc/init.d/postgresql stop<br><br>
3) Elimina el directorio data (puedes crear otro cluster en lugar de
eliminar este directorio, en mi caso se trataba de portar una BD
antigua a la version 8.3 del postgres, por eso quise eliminar este
directorio).<br>
rm -rf /var/lib/pgsql/data<br><br>
4) Actúa como usuario postgres<br>
su - postgres<br><br>
5) Crea un nuevo cluster indicandole el locale que necesites (en mi
caso, es_CO.LATIN1) pero puedes usar el de tu país, es_ES.LATIN1,
es_AR.ut8, etc. Nota: La codificacion (opcion -E) no es necesaria
puesto que se deriva de locale.<br><br>
initdb --locale=es_CO.LATIN1 -D /var/lib/pgsql/data<br><br>
6) Listo, ahora seguramente querrás que el postgres te inicie automáticamente en los niveles 3 y 5.<br><br>
exit (para salir de la sesión del usuario postgres y volver a root)<br>
chkconfig --level 35 postgresql on<br><br>
7) Prueba a reiniciar el servicio... si tienes algun problema comentalo aquí.<br><br>
rcpostgresql restart<br><br>
8) Si todo te sale bien, ya puedes crear tu base de datos.<br>
createdb -U postgres -E LATIN1 nombrebd<br></b>
<br>I hope this helps<br><br>Bram<br><br clear="all">@mire - <a href="http://www.atmire.com">http://www.atmire.com</a><br><br>Technologielaan 9 - 3001 Heverlee - Belgium<br>533 2nd Street - Encinitas, CA 92024 - USA<br>
<br><a href="http://www.togather.eu">http://www.togather.eu</a> - Before getting together, get Tog@ther <br>
<br><br><div class="gmail_quote">2009/9/10 Héctor Garcia Peris <span dir="ltr"><<a href="mailto:hector.garcia@ivie.es">hector.garcia@ivie.es</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
The problem is when I try to create the database using UNICODE I get<br>
this error:<br>
<br>
dspace@dspace:~$ /usr/lib/postgresql/8.3/bin/createdb -U dspace -E<br>
UNICODE dspace2<br>
createdb: falló la creación de la base de datos:<br>
ERROR: la codificación UTF8 no coincide con la configuración regional<br>
del servidor es_ES<br>
DETAIL: La configuración regional LC_CTYPE del servidor requiere la<br>
codificación LATIN1.<br>
<br>
Sorry, but the message is in Spanish. I try to translate it:<br>
<br>
createdb: failed in the database creation<br>
ERROR: UTF8 codification doesn't coincide with the regional<br>
configutation of the server es_ES<br>
DETAIL: Regional codification LC_CTYPE of the server requires LATIN1<br>
codification.<br>
<br>
This is the reason because my database is created with LATIN1. Any help<br>
to create it with UNICODE is welcome.<br>
<br>
Thanks.<br>
<br>
Hilton Gibson escribió:<br>
<div><div></div><div class="h5">> On Wednesday 09 September 2009 15:00:33 Héctor Garcia Peris wrote:<br>
><br>
>> I think the problem is related with the codification. If I create an<br>
>> item with special characters like "Título 1", when I run this:<br>
>><br>
>> dspace@dspace:~$ /home/dspace/dspace/bin/index-update<br>
>> Creating browse index<br>
>> Exception in thread "main" org.dspace.browse.BrowseException:<br>
>> org.postgresql.util.PSQLException: ERROR: carácter 0xcc81 de<br>
>> codificación «UTF8» no tiene equivalente en «LATIN1»<br>
>> <lines suppressed><br>
>><br>
>> without special characters I have no problem.<br>
>><br>
>> The problem is that I couldn't create the database if I don't use LATIN1<br>
>> codification. How can I create the database with the UNICODE codification?<br>
>><br>
> See:<br>
> <a href="http://services.lib.sun.ac.za/wiki/index.php/Install_Dspace_Server_Setup#Enable_Tomcat_with_UTF-8_multi-" target="_blank">http://services.lib.sun.ac.za/wiki/index.php/Install_Dspace_Server_Setup#Enable_Tomcat_with_UTF-8_multi-</a><br>
> byte_encoding<br>
><br>
> <a href="http://services.lib.sun.ac.za/wiki/index.php/Install_Dspace_Server_Setup#Create_the_PostgreSQL_.27dspace.27_database" target="_blank">http://services.lib.sun.ac.za/wiki/index.php/Install_Dspace_Server_Setup#Create_the_PostgreSQL_.27dspace.27_database</a><br>
><br>
> Cheers<br>
><br>
> hg.<br>
><br>
><br>
>> Thanks.<br>
>><br>
>> Claudia Jürgen escribió:<br>
>><br>
>>> Hola Héctor,<br>
>>><br>
>>> did you ran<br>
>>> [dspace]/bin/index-init after the fresh installation?<br>
>>><br>
>>> Saludos<br>
>>><br>
>>> Claudia Jürgen<br>
>>><br>
>>> Héctor Garcia Peris schrieb:<br>
>>><br>
>>>> Hello,<br>
>>>><br>
>>>> I have installed dspace 1.5.2 in a debian linux stable version.<br>
>>>><br>
>>>> The installation uses postgres as database and is a new installation.<br>
>>>> I have created a testing community and a testing collection without<br>
>>>> problems. But when I have created a new item, although it was created<br>
>>>> without problems I can't see it in the collection<br>
>>>> (<a href="http://dspace:8080/jspui/handle/123456789/2" target="_blank">http://dspace:8080/jspui/handle/123456789/2</a>) or when I try to find<br>
>>>> it using the search engine<br>
>>>> (<a href="http://dspace:8080/jspui/simple-search?query=&submit=Ir+" target="_blank">http://dspace:8080/jspui/simple-search?query=&submit=Ir+</a>).<br>
>>>> Nevertheless I can access to the item data using the URI associated<br>
>>>> to it (<a href="http://dspace:8080/jspui/handle/123456789/3" target="_blank">http://dspace:8080/jspui/handle/123456789/3</a>).<br>
>>>><br>
>>>> It seems that there is something missing between the collection and<br>
>>>> the item. Can anybody help me?<br>
>>>><br>
>>>> Thanks.<br>
>>>><br>
><br>
> _______________________________________________<br>
> Dspace-general mailing list<br>
> <a href="mailto:Dspace-general@mit.edu">Dspace-general@mit.edu</a><br>
> <a href="http://mailman.mit.edu/mailman/listinfo/dspace-general" target="_blank">http://mailman.mit.edu/mailman/listinfo/dspace-general</a><br>
><br>
<br>
</div></div><div class="im">--<br>
<br>
---------------------------------------------------------------------<br>
Héctor Garcia Peris<br>
Dpto. Informática<br>
Instituto Valenciano de Investigaciones Económicas S.A. (Ivie)<br>
C/ Guardia Civil, 22 esc-2 1º 46020 - Valencia (Spain)<br>
Tfno.: +34 - 963190050 / +34 - 963930816<br>
Fax.: +34 - 963190055 / +34 - 963930856<br>
e-mail: <a href="mailto:hector.garcia@ivie.es">hector.garcia@ivie.es</a><br>
Web: <a href="http://www.ivie.es" target="_blank">http://www.ivie.es</a><br>
----------------------------------------------------------------------<br>
<br>
_______________________________________________<br>
</div><div><div></div><div class="h5">Dspace-general mailing list<br>
<a href="mailto:Dspace-general@mit.edu">Dspace-general@mit.edu</a><br>
<a href="http://mailman.mit.edu/mailman/listinfo/dspace-general" target="_blank">http://mailman.mit.edu/mailman/listinfo/dspace-general</a><br>
</div></div></blockquote></div><br>