On Fri, Jan 29, 2010 at 5:12 PM, ngocdaothanh <ngocdaoth...@gmail.com>wrote:
> I would like to switch from MySQL to PostgreSQL but have no experience > with PostgreSQL's way of master/slave replication. What tool do you > recommend? > > I have not used PostgreSQL in replicated mode. Sorry. > Thanks. > > > On Jan 30, 3:48 am, David Pollak <feeder.of.the.be...@gmail.com> > wrote: > > On Fri, Jan 29, 2010 at 6:06 AM, Adam Warski <a...@warski.org> wrote: > > > Heh, sorry, I knew the moment I write a post here I'll find the answer > ;) > > > > > Forgot that when converting a table in mysql you not only need to set > the > > > character encoding for the table but also for the individual columns. > > > > My experience has been that PostgreSQL doesn't have these kind of issues > and > > is generally faster and more stable than MySQL. FYI. > > > > > > > > > > > > > Sorry again for the spam. > > > > > On Jan 29, 2010, at 3:01 PM, Adam Warski wrote: > > > > > > Hello, > > > > > > maybe you have some ideas. I'm trying to make my lift app able to > store > > > polish characters, and I'm slowly running out of ideas. > > > > I think it's something with mapper configuration, but I'm not sure. > > > > > > When I submit a form with an "ą" character, I get the following > > > exception: > > > > > > Message: java.sql.SQLException: Incorrect string value: '\xC4\x85' > for > > > column 'title' at row 1 > > > > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) > > > > > > What I did so far: > > > > - the mysql table encoding is utf-8 > > > > - the connection string contains > useUnicode=true&characterEncoding=UTF-8 > > > > - LiftRules.early.append(_.setCharacterEncoding("UTF-8")) > > > > > > When the String is set on the model field it still is correct, so > > > something happens when trying to persist the value. Is there a way in > lift > > > to configure jdbc so that it accepts utf-8 characters? Or am I missing > > > something else? > > > > > > -- > > > > Adam Warski > > > >http://www.warski.org > > > >http://www.softwaremill.eu > > > > > > -- > > > > You received this message because you are subscribed to the Google > Groups > > > "Lift" group. > > > > To post to this group, send email to lift...@googlegroups.com. > > > > To unsubscribe from this group, send email to > > > liftweb+unsubscr...@googlegroups.com<liftweb%2bunsubscr...@googlegroups.com> > <liftweb%2bunsubscr...@googlegroups.com<liftweb%252bunsubscr...@googlegroups.com> > > > > > . > > > > For more options, visit this group at > > >http://groups.google.com/group/liftweb?hl=en. > > > > > -- > > > Adam Warski > > >http://www.warski.org > > >http://www.softwaremill.eu > > > > > -- > > > You received this message because you are subscribed to the Google > Groups > > > "Lift" group. > > > To post to this group, send email to lift...@googlegroups.com. > > > To unsubscribe from this group, send email to > > > liftweb+unsubscr...@googlegroups.com<liftweb%2bunsubscr...@googlegroups.com> > <liftweb%2bunsubscr...@googlegroups.com<liftweb%252bunsubscr...@googlegroups.com> > > > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/liftweb?hl=en. > > > > -- > > Lift, the simply functional web frameworkhttp://liftweb.net > > Beginning Scalahttp://www.apress.com/book/view/1430219890 > > Follow me:http://twitter.com/dpp > > Surf the harmonics > > -- > You received this message because you are subscribed to the Google Groups > "Lift" group. > To post to this group, send email to lift...@googlegroups.com. > To unsubscribe from this group, send email to > liftweb+unsubscr...@googlegroups.com<liftweb%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/liftweb?hl=en. > > -- Lift, the simply functional web framework http://liftweb.net Beginning Scala http://www.apress.com/book/view/1430219890 Follow me: http://twitter.com/dpp Surf the harmonics -- You received this message because you are subscribed to the Google Groups "Lift" group. To post to this group, send email to lift...@googlegroups.com. To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/liftweb?hl=en.