<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Nachricht</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16705" name=GENERATOR><!-- converted from rtf -->
<STYLE>.EmailQuote {
PADDING-LEFT: 4pt; MARGIN-LEFT: 1pt; BORDER-LEFT: #800000 2px solid
}
</STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=320120411-22102008>Hallo
Herr Stolz,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=320120411-22102008></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=320120411-22102008>nein,
ich habe bis jetzt keine Antwort erhalten und - auch nach längerer "Forschung" -
keine Lösung gefunden.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=320120411-22102008>Bis
jetzt war das für mich auch nicht SOO dringend; mit der Verfügbarkeit von MB 2.5
als "stable" release würde es aber gerade sehr gut passen, wenn Sie eine Lösung
auftun könnten. </SPAN></FONT><FONT face=Arial color=#0000ff size=2><SPAN
class=320120411-22102008>Jetzt stellt sich für mich dieses Thema konkret
:-(</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=320120411-22102008></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=320120411-22102008>Anmerkung: Ich habe auch intensiv nach Lösungen
gegoogelt. Alles was ich verstand (in einer spanisch-sprachigen mailing-liste
(ich spreche allerdings kein spanisch)) war, dass es einfach nicht geht
!</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=320120411-22102008></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=320120411-22102008>Vielen
Dank trotzdem, wenn Sie bei fachkundiger Stelle nachfragen !</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=320120411-22102008></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=320120411-22102008>mfg</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=320120411-22102008>Schönhammer Herbert</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left><FONT face=Tahoma
size=2>-----Ursprüngliche Nachricht-----<BR><B>Von:</B> Dietmar Stolz
[mailto:dietmar.stolz@netcologne.de] <BR><B>Gesendet:</B> Dienstag, 21.
Oktober 2008 13:20<BR><B>An:</B> Schönhammer, Herbert<BR><B>Betreff:</B> Re:
[Mapbender-users] How to create a postgres-cluster with encodingsUTF-8 and
LATIN1 ?<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hallo Herr Schönhammer,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>haben Sie eine Antwort/eine Lösung
erhalten?</FONT></DIV>
<DIV><FONT face=Arial size=2>Stehe vor dem gleichen Problem und finde -
wenigstens auf die Schnelle - keine Lösung.</FONT></DIV>
<DIV><FONT face=Arial size=2>Wüßte aber evtl. Leute die ich ansprechen
könnte.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Liebe Grüße aus Bonn</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> Dietmar Stolz</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=Schoenhammer.Herbert@Regensburg.de
href="mailto:Schoenhammer.Herbert@Regensburg.de">Schönhammer, Herbert</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=mapbender_users@lists.osgeo.org
href="mailto:mapbender_users@lists.osgeo.org">mapbender_users@lists.osgeo.org</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, June 23, 2008 2:00
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Mapbender-users] How to
create a postgres-cluster with encodingsUTF-8 and LATIN1 ?</DIV>
<DIV><BR></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>
<P>
<HR>
<P></P>_______________________________________________<BR>Mapbender_users
mailing
list<BR>Mapbender_users@lists.osgeo.org<BR>http://lists.osgeo.org/mailman/listinfo/mapbender_users<BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>