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
---
http://www.fiee.net
https://www.cacert.org (I'm an assurer)
_______________________________________________
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/1de2976a-8278-45de-8931-f0dd60f10...@fiee.net
