Re: Encoding/collation question
Andrew Gierth <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <[email protected]> |
>>>>> "Rich" == Rich Shepard <[email protected]> writes: Rich> I doubt that my use will notice meaningful differences. Since Rich> there are only two or three databases in UTF8 and its collation Rich> perhaps I'll convert those to LATIN1 and C. Note that it's perfectly fine to use UTF8 encoding and C collation (this has the effect of sorting strings in Unicode codepoint order); this is as fast for comparisons as LATIN1/C is. For those cases where you need data to be sorted in a culturally-meaningful order rather than in codepoint order, you can set collations on specific columns or in individual queries. -- Andrew (irc:RhodiumToad)