[BUGS] BUG #2300: Error in upper function
The following bug has been logged online: Bug reference: 2300 Logged by: Kashin Oleg Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Suse 9.1 Description:Error in upper function Details: My database is with UTF8 encoding. When I use function "upper" for any filed of table I get the next error "Invalid multibyte character for locale". Example: select from users where upper(user_login) like '%'; I rewrote such SQL query like next one - select from users where lower(user_login) like '%'; and everything now is ok. Thanks. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[BUGS] BUG #2345: odbc driver doesn't work
The following bug has been logged online: Bug reference: 2345 Logged by: Kashin Oleg Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: FreeBSD Description:odbc driver doesn't work Details: Hello! I've the trouble. I'd installed unixodbc 2.2.11 under freeBSD-4.8 and complided psqlodbc driver-v.08.01.0200. I made all necessary things to use odbc driver byt it doesn't work. When I use standart driver for postgres from unixodbc all is ok. Fot test I use isql programm. I tried to do all the same under linux (Suse 9.1) and this driver works in spite of I compiled unixodbc and psqlodbc driver as well. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
