Thread: LIKE and encoding and locale
I found this thread on the general list about 2 months ago:
http://marc.theaimsgroup.com/?l=postgresql-general&m=108271530922498&w=2
Is there any plans to make unicode more usable for sorting, LIKE, and LOCALE in the future? Reading that thread, and
allthe manuals, it seems that unicode is very limited; It really only works in one langauge in a database. So in
reality,it'd just be simpler to use an 8 bit encoding on any postgres database, and a new database for each and every
langaugethat needs to be used by a company/site, if I have understood all the implications.
Yes there are. Tom the Magi has come up with a patch for that I believe. Search the hackers mailing list but I think it has a shot at making it in 7.5 Mike On Wed, 2004-06-23 at 23:18, Dennis Gearon wrote: > I found this thread on the general list about 2 months ago: > > http://marc.theaimsgroup.com/?l=postgresql-general&m=108271530922498&w=2 > > Is there any plans to make unicode more usable for sorting, LIKE, and LOCALE in the future? Reading that thread, and allthe manuals, it seems that unicode is very limited; It really only works in one langauge in a database. So in reality,it'd just be simpler to use an 8 bit encoding on any postgres database, and a new database for each and every langaugethat needs to be used by a company/site, if I have understood all the implications. > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings
I take that back... I was thinking of Upper/Lower in Unicode. Sorry for the possible misinfo. mike g wrote: > Yes there are. Tom the Magi has come up with a patch for that I > believe. Search the hackers mailing list but I think it has a shot at > making it in 7.5 > > Mike > On Wed, 2004-06-23 at 23:18, Dennis Gearon wrote: > > I found this thread on the general list about 2 months ago: > > > > http://marc.theaimsgroup.com/?l=postgresql-general&m=108271530922498&w=2 > > > > Is there any plans to make unicode more usable for sorting, LIKE, and LOCALE in the future? Reading that thread, andall the manuals, it seems that unicode is very limited; It really only works in one langauge in a database. So in reality,it'd just be simpler to use an 8 bit encoding on any postgres database, and a new database for each and every langaugethat needs to be used by a company/site, if I have understood all the implications. > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 7: don't forget to increase your free space map settings > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org