Rony Khoury writes:
> example
> new version:
> BOU MOUSLEH
> BOUSTANI
> BOU YAZBEK
>
> old version
> BOU MOUSLEH
> BOU YAZBECK
> BOUSTANI
Seems like the two installations are running under different locales.
Since you didn't give much information I can only guess that the "old
version" is prior to 7.1 and running in some non-C locale, whereas the
"new version" is 7.1 or later but was initialized in the C locale. Note
that 7.1 or later always use the locale at initdb time for sort order.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter