On Sunday 13 September 2009 12:59:01 pm Adrian Klaver wrote:
> On Sunday 13 September 2009 12:45:37 pm Henning Hraban Ramm wrote:
> > Am 2009-09-12 um 21:08 schrieb Jeff Johnson:
> > > I would like to express an opinion regarding MSSql vs. PostgreSQL just
> > > in case someone might be interested. I created two databases based on
> > > an actual MSSql database that I will be pulling from in production.
> > > One
> > > in MSSql and one in PostgreSQL. Other than VFP I have done quite a
> > > bit
> > > of experience accessing MSSql but I had no experience with PostgreSQL.
> > > After a couple of days I feel I know PostgreSQL much better than the
> > > other. It is almost intuitive and very easy to work with (maybe
> > > from my
> > > VFP experience). Because it is open source it seems to be a *lot*
> > > easier to get questions answered. My analogy would be a Cadillac
> > > vs. a
> > > Miata. One has all of the bells and whistles and the other just plain
> > > works and is a lot more fun to drive.
> >
> > I've a lot of experience with MySQL and a bit with SQLite.
> >
> > After all the praise for PostgreSQL on this list I tried to use it
> > when I recently set up a new webserver.
> >
> > After searching the docs and the Internets for a while I had to
> > conclude that PostgreSQL doesn't allow to use different text encodings
> > (collations) for different tables - even worse, the encoding is hard-
> > compiled, and UTF-8 is only possible with "C" locale.
> > That's totally out of the question and a horribly outdated approach!
> > So I went back to MySQL.
> >
> > Maybe I did or understood something wrong - but I can't say it would
> > be easy to set up a working PostSQL server. ("Only one 8-bit encoding"
> > *is* "not working".)
> >
> > Greetlings from Lake Constance!
> > Hraban
> > ---
>
> You are right about different encodings for different tables. As of 8.3 you
> can have different encodings for databases within a cluster but that is far
> as it extends at the moment. Your comments about UTF-8 are wrong though.
> See the link for a better explanation:
> http://www.postgresql.org/docs/8.4/interactive/multibyte.html
I missed that he was talking about tables and not databases.
Johnf
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/200909131307.05632.jfabi...@yolo.com
