William Sweet wrote: > support is enabled. Now, I'd like to only store Unicode chars in my > PostgreSQL dbs. I hear there are 3 ways to accomplish this: > > 1) during PostgreSQL configure/build (installation level) > 2) during initdb (cluster level) > 3) CREATE DATABASE (db level) Each one of these only sets the default for the one below it. > ...but there are some "not-so-happy" stories on the net. For > instance, "it's not 'true' Unicode support when implemented at the db > level", That is bogus. > or "sorting and regex do not work properly with a cluster > level implementation", That is true. etc. I've read the v7.3 Admin Guide section > 7.2 Multibyte support... sounds reasonable. So my question is, what > is the official way to enable "true" Unicode storage and retrieval, > so that LIKE, sorting, and regex in perl::DBI work properly? Sorting will not work correctly with Unicode. > I am a > tad concerned also that I don't see PostgreSQL mentioned on the > Unicode products page; http://www.unicode.org/onlinedat/products.html Well, we're also not listed on the ISO 8859 products page, but I don't think that matters. :-) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
