<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style>.EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; }</style>
</head>
<body>
<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>
</body>
</html>