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
--
Adrian Klaver
akla...@comcast.net
_______________________________________________
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/200909131259.01830.akla...@comcast.net
