On Tuesday, 6 October 2015 12:26:06 UTC-4, Jeremy Evans wrote: > > On Tuesday, October 6, 2015 at 9:17:49 AM UTC-7, Andrew Waltman wrote: >> >> I am in the process of migrating an ruby/sequel application from using a >> MySQL database to an Oracle database. It is going well except there is a >> minor issue where we would like to use integer/numeric columns to persist >> boolean values to be consistent with our Oracle databases used by an >> ActiveRecord application. Is there a way to get Sequel's Oracle adapter to >> use 0 and 1 for false and true similar to the way the SQLite adapter >> uses the integer_booleans setting? It seems that the default for the Oracle >> adapter is to use the 'Y' and 'N' characters for true and false. >> > > Andrew, > > There currently isn't a way to use integer booleans on Oracle. Oracle > itself uses Y/N for boolean values, so that is what the Sequel oracle > adapter supports. > > Thanks, > Jeremy >
Thanks for the quick reply! It is unfortunate that we won't be able to use the same column types, but we'll make it work. Besides that, the migration from MySQL to Oracle using Sequel has been nearly transparent. Thank you for all the work you've put into the toolkit! Andrew -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
