Hitesh Bagadiya <bagadiya@yahoo.com> writes: > We did set the locate to hi_IN at initdb but sorting is not > working. You should check that you have selected a database encoding that matches what the locale expects. Also double-check that you really do have that locale selected (use pg_controldata, or in 7.4 just "show lc_collate"). regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster