The following bug has been logged online: Bug reference: 2155 Logged by: Vic Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.5 Operating system: FreeBSD 6.0 Description: problem with UNICODE and KOI8 Details:
Database have enconding UNICODE. Client have KOI8, "lower" function not convert to lower case any russian worlds, but english words convertable: acct=> \encoding KOI8 acct=> select lower('ÐÑовеÑка'); lower ---------- ÐÑовеÑка (1 запиÑÑ) acct=> select lower('Test'); lower ------- test (1 запиÑÑ) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match