<!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">
<div class="moz-text-flowed"
style="font-family: -moz-fixed; font-size: 13px;" lang="x-western">I've
been reading about locales, encodings, sort orders, the to_ascii
<br>
function and, embarrasingly, I'm more confused than enlightened.:
<br>
<br>
What I want is very simple:
<br>
1) I want the database to correctly accept, store, and display
<br>
alphabetic characters, including European accented characters, entered
and viewed in HTML
<br>
forms.
<br>
2) I want sorting to ignore the diacritical marks so that, for example,
<br>
u, u-accent, and u-umlaut are all sorted as if they were plain u.
<br>
3) I want sorting to ignore non-alphanumerics, letter case, and white
space.
<br>
<br>
To illustrate, the following data is in sorted order:
<br>
<br>
St-Émile
<br>
stendahl
<br>
st ènders
<br>
St. Epson
<br>
<br>
Can someone tell me what combination of PostgreSQL and Linux settings I
<br>
need for this? It seems like a very basic question, but I'm just dense,
<br>
I guess. I've tried a half dozen time-consuming configs without
success.
<br>
<br>
Thank you.
<br>
<br>
John Gunther
<br>
<br>
<br>
</div>
</body>
</html>