Hi Herbert, did you read it?<br><br><a href="http://www.postgresql.org/docs/8.3/interactive/multibyte.html">http://www.postgresql.org/docs/8.3/interactive/multibyte.html</a><br><br>Hope it helps you.<br><br><br>Germán Carrillo<br>
<br><br><div class="gmail_quote">2008/6/23 Germán Carrillo <<a href="mailto:carrillo.german@gmail.com">carrillo.german@gmail.com</a>>:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Herbert, in spanish mailing list Alvaro Herrera says:<br><br>Since PostgreSQL 8.3 there is a change, before 8.3 the server enables you to choose a different encoding to regional configuration. This was very problematic for the postgres team. For this reason, now you can't combine (in only one postmaster) databases with Latin1 and UTF-8.<br>
<br>The alternative is you choose the C or POSIX regional configuration, which can work with any encoding.<br><br><br>You can find more information on the postgres mailing list (spanish):<br><a href="http://archives.postgresql.org/pgsql-es-ayuda/2008-02/msg00431.php" target="_blank">http://archives.postgresql.org/pgsql-es-ayuda/2008-02/msg00431.php</a><br>
<br><br>I also tried the LATIN1 encoding without any results. If you can resolve it please write it. <br><br>Thanks and best regards.<br><br><br>Germán Carrillo.<br><br><br><div class="gmail_quote">2008/6/23 Schönhammer, Herbert <<a href="mailto:Schoenhammer.Herbert@regensburg.de" target="_blank">Schoenhammer.Herbert@regensburg.de</a>>:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="Wj3C7c">
<div>
<font face="Arial, sans-serif" size="3">
<div> </div>
<div><font size="2">Hi list, </font></div>
<div><font size="2"> </font></div>
<div><font size="2">Obviously this posting is in the wrong list. But perhaps somebody reading this list has a solution for me. My problems are:</font></div>
<div><font size="2"> </font></div>
<div><font size="2">I want to create a postgres-cluster, in which it should be possible to generate databases with encodings in</font></div>
<div><font size="2"> </font></div>
<div><font size="2">- UTF-8 for use as mapbender-db </font></div>
<div><font size="2">- LATIN1 for storing data in german sort-order and character-set</font></div>
<div><font size="2"> </font></div>
<div><font size="2">Using postgresql version <= 8.2.x this is no problem. The postgresql does not evaluate the system's LC_CTYPE and so the postgres-user is able to create db's with all wanted encodings.</font></div>
<div><font size="2"> </font></div>
<div><font size="2">But since postgres 8.3.x the initdb evaluates the system LC_CTYPE (which is set to de_DE.UTF-8). I'm ONLY allowed to generate databases with encoding UTF-8. </font></div>
<div><font size="2"> </font></div>
<div><font size="2">I have tried using the --locale option of initdb, setting --locale=de_DE.LATIN1. The result is, I'm only allowed to create databases with encoding LATIN1.</font></div>
<div><font size="2"> </font></div>
<div><font size="2">Also following the Postgres-doc, i tried --locale=C or --local=POSIX, setting --lc-collate=de_DE.LATIN1: But I'm also only allowd to create databases with encoding UTF-8.</font></div>
<div><font size="2"> </font></div>
<div><font size="2">Does anybody know, how to specify the initdb options to generate mapbender-db's in UTF-8 and "data"-db's in LATIN1 ?</font></div>
<div><font size="2"> </font></div>
<div><font size="2">I urgently need some help ;-)</font></div>
<div><font size="2"> </font></div>
<div><font size="2">Thanks and greetings from</font></div>
<div><font size="2">Herbert</font></div>
<div><font size="2"> </font></div>
</font>
</div>
<br></div></div>_______________________________________________<br>
Mapbender_users mailing list<br>
<a href="mailto:Mapbender_users@lists.osgeo.org" target="_blank">Mapbender_users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapbender_users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapbender_users</a><br>
<br></blockquote></div><font color="#888888"><br><br clear="all"><br>-- <br>-----------<br> |\__ <br>(:>__)(<br> |/ <br><br>Soluciones Geoinformáticas Libres <br><a href="http://geotux.tuxfamily.org/" target="_blank">http://geotux.tuxfamily.org/</a><br>
<br>
</font></blockquote></div><br><br clear="all"><br>-- <br>-----------<br> |\__ <br>(:>__)(<br> |/ <br><br>Soluciones Geoinformáticas Libres <br><a href="http://geotux.tuxfamily.org/">http://geotux.tuxfamily.org/</a><br>
<br>