On Wed, 3 Dec 2003, Alvaro Herrera wrote: > On Wed, Dec 03, 2003 at 11:42:34PM +0300, E.Rodichev wrote: > > On Wed, 3 Dec 2003, Stephan Szabo wrote: > > > > > No, it isn't. As far as PostgreSQL is concerned the database is SQL_ASCII > > > since you didn't override the default encoding at initdb time or at > > > createdb time. You did choose LC_ values that seem to want KOI8, but > > > locale and encoding are separate, if you want KOI8 encoding, you have to > > > say so. > > > > Yes, it is! > > What apparently you haven't picked up yet is that the _locale_ is a > different and unrelated configuration setting from the _encoding_. > Sort order is locale related; you already got that one right. Now you
Sorry, I got it WRONG! Sort order for C locale MUST be the abcABC, not aAbBcC. But I got aAbBcC. Best wishes, E.R. > need to go after the encoding. > > -- > Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) > "El destino baraja y nosotros jugamos" (A. Schopenhauer) > _________________________________________________________________________ Evgeny Rodichev Sternberg Astronomical Institute email: [EMAIL PROTECTED] Moscow State University Phone: 007 (095) 939 2383 Fax: 007 (095) 932 8841 http://www.sai.msu.su/~er ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match