Re: Notes on converting from MySQL 5.0.x to PostgreSQL
От | Franz.Rasper@izb.de |
---|---|
Тема | Re: Notes on converting from MySQL 5.0.x to PostgreSQL |
Дата | |
Msg-id | 11EC9A592C31034C88965C87AF18C2A709BED3@m0000s61 обсуждение исходный текст |
Список | pgsql-general |
Yes indeed if it would be possible, it should go to the website. Good comparison without saying such things like this dbms has xx features and this one has xx features. Some addtitional information for setcion "Further information:" phpPgAdmin http://phppgadmin.sourceforge.net/ Gborg http://gborg.postgresql.org/ Greetings, -Franz -----Ursprüngliche Nachricht----- Von: Tom Lane [mailto:tgl@sss.pgh.pa.us] Gesendet: Freitag, 30. Juni 2006 16:17 An: Jason McManus Cc: pgsql-general@postgresql.org Betreff: Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4 "Jason McManus" <mcmanus.jason@gmail.com> writes: > I am in the process of converting a couple of major sites from MySQL 5.0.22 > to PostgreSQL 8.1.4, and I thought I would share some of my observations on > this process and the two database systems in general. Nice notes! I see only one small error: > * Pg's default character set (in 8.1.4) is UTF8. I don't believe there is any fixed "default character set". Each installation will have a default locale and encoding, but these depend on the locale under which initdb was run. From the above comment I surmise that you initdb'd under some UTF8-using locale ... > Thank you, and I hope that these notes prove helpful to others! Perhaps they should go on the project website somewhere? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
В списке pgsql-general по дате отправления: