SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 09:04 AM
| ||||
| ||||
 BUG #1813: lower() function doesn't work on unicode database The following bug has been logged online: Bug reference: 1813 Logged by: yoursoft Email address: yoursoft@freemail.hu PostgreSQL version: 8.0.3 Operating system: SuSE 9.3 professional Description: lower() function doesn't work on unicode database Details: We have a filesystem with latin2. The database created in unicode. When we insert some Hungarian chars into it, and make a 'select kifejezes from table' the result is fine. When make 'select lower(kifejezes) from table', the result is wrong. If any questions with the bug, please mail to yoursoft@freemail.hu. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly      |
|
04-10-2008, 09:04 AM
| ||||
| ||||
| Re: BUG #1813: lower() function doesn't work on unicode On Sat, 6 Aug 2005, yoursoft wrote: > The following bug has been logged online: > > Bug reference: 1813 > Logged by: yoursoft > Email address: yoursoft@freemail.hu > PostgreSQL version: 8.0.3 > Operating system: SuSE 9.3 professional > Description: lower() function doesn't work on unicode database > Details: > > We have a filesystem with latin2. The database created in unicode. > When we insert some Hungarian chars into it, and make a 'select kifejezes > from table' the result is fine. > When make 'select lower(kifejezes) from table', the result is wrong. > If any questions with the bug, please mail to yoursoft@freemail.hu. What was the locale set to for the call to initdb (try "SHOW LC_CTYPE;")? The first things to check are that the locale is for Hungarian and that it is a UTF8 locale if the database is unicode. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
 |
« BUG #1810: Select * From XXX where xfield = 'Chinese_String';
|
Re: BUG #1806: Postmaster takes uses 99% of CPU »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 11:08 PM.
