<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Alvaro Herrera wrote:
<blockquote cite="mid20060821001057(dot)GB1130(at)alvh(dot)no-ip(dot)org" type="cite">
<blockquote type="cite">
<pre wrap="">For example, with all LC_* parameters set to "en_US.UTF8", I get the
following incorrect "order:by":
Béarn
Bécancour
Beaupré
</pre>
</blockquote>
<pre wrap=""><!---->
Did you initdb with locale en_US.UTF8, and also createdb with encoding
UTF8? While you can certainly choose mismatching values in createdb and
initdb, you shouldn't because it doesn't work.</pre>
</blockquote>
That's an interesting question. Are the LC_* variables set by initdb or
createdb? In other words, does their value indicate what initdb
settings I used? If I do a default createdb, will the new database
automatically be consistent with the cluster's initdb?<br>
</body>
</html>