SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 06:57 AM
| ||||
| ||||
 Ordering and unicode I have a database on PostgreSQL 8.0.3 with unicode (utf-8) encoding, client encoding is set to unicode, too. LC_COLLATE for the cluster is de_DE.iso885915@euro. I noticed that that collation doesn't work for two-byte characters, apparently they are ordered bytewise. My current conjecture is that I'd have to re-initialize the cluster with a utf-8 collation. Is this correct? Right now I don't have access to the machine and can't check this. Michael -- Michael Schuerig Face reality and stare it down mailto:michael@schuerig.de --Jethro Tull, Silver River Turning http://www.schuerig.de/michael/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend      |
|
04-09-2008, 06:57 AM
| ||||
| ||||
| Re: Ordering and unicode On Thursday 10 November 2005 21:31, Michael Schuerig wrote: > I have a database on PostgreSQL 8.0.3 with unicode (utf-8) encoding, > client encoding is set to unicode, too. LC_COLLATE for the cluster is > de_DE.iso885915@euro. I noticed that that collation doesn't work for > two-byte characters, apparently they are ordered bytewise. > > My current conjecture is that I'd have to re-initialize the cluster > with a utf-8 collation. Is this correct? Right now I don't have > access to the machine and can't check this. Yes, it is the case. Just checked on another installation. Thanks for listening... Michael -- Michael Schuerig Thinking is trying to make up mailto:michael@schuerig.de for a gap in one's education. http://www.schuerig.de/michael/ --Gilbert Ryle ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
 |
« Locale/Indexing
|
table copy »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 11:32 AM.
