[prev in list] [next in list] [prev in thread] [next in thread]
List: mapbender-users
Subject: Re: [Mapbender-users] How to create a postgres-cluster with encodings
From: "=?ISO-8859-1?Q?Germ=E1n_Carrillo?=" <carrillo.german () gmail ! com>
Date: 2008-06-27 18:39:56
Message-ID: e32d76a10806271139y2e6c6594ndde4c222cf0caa8b () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi Herbert, did you read it?
http://www.postgresql.org/docs/8.3/interactive/multibyte.html
Hope it helps you.
Germán Carrillo
2008/6/23 Germán Carrillo <carrillo.german@gmail.com>:
> Hi Herbert, in spanish mailing list Alvaro Herrera says:
>
> 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.
>
> The alternative is you choose the C or POSIX regional configuration, which
> can work with any encoding.
>
>
> You can find more information on the postgres mailing list (spanish):
> http://archives.postgresql.org/pgsql-es-ayuda/2008-02/msg00431.php
>
>
> I also tried the LATIN1 encoding without any results. If you can resolve it
> please write it.
>
> Thanks and best regards.
>
>
> Germán Carrillo.
>
>
> 2008/6/23 Schönhammer, Herbert <Schoenhammer.Herbert@regensburg.de>:
>
>>
>> Hi list,
>>
>> Obviously this posting is in the wrong list. But perhaps somebody reading
>> this list has a solution for me. My problems are:
>>
>> I want to create a postgres-cluster, in which it should be possible to
>> generate databases with encodings in
>>
>> - UTF-8 for use as mapbender-db
>> - LATIN1 for storing data in german sort-order and character-set
>>
>> 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.
>>
>> 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.
>>
>> 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.
>>
>> 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.
>>
>> Does anybody know, how to specify the initdb options to generate
>> mapbender-db's in UTF-8 and "data"-db's in LATIN1 ?
>>
>> I urgently need some help ;-)
>>
>> Thanks and greetings from
>> Herbert
>>
>>
>> _______________________________________________
>> Mapbender_users mailing list
>> Mapbender_users@lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapbender_users
>>
>>
>
>
> --
> -----------
> |\__
> (:>__)(
> |/
>
> Soluciones Geoinformáticas Libres
> http://geotux.tuxfamily.org/
>
>
--
-----------
|\__
(:>__)(
|/
Soluciones Geoinformáticas Libres
http://geotux.tuxfamily.org/
[Attachment #5 (text/html)]
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>
_______________________________________________
Mapbender_users mailing list
Mapbender_users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapbender_users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic