Skip to content

Instantly share code, notes, and snippets.

@annaswims
Created May 2, 2014 02:54
Show Gist options
  • Save annaswims/c79c4c10fe951f2673ea to your computer and use it in GitHub Desktop.
Save annaswims/c79c4c10fe951f2673ea to your computer and use it in GitHub Desktop.
sqlserver odbc
1) Error:
BasicsTest#test_unicode_column_name:
Encoding::CompatibilityError: incompatible character encodings: ASCII-8BIT and UTF-8
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:359:in `do_exec_query'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:33:in `exec_query'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:39:in `exec_insert'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:96:in `insert'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `insert'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/relation.rb:76:in `insert'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/persistence.rb:509:in `create_record'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/attribute_methods/dirty.rb:78:in `create_record'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/callbacks.rb:306:in `block in create_record'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activesupport/lib/active_support/callbacks.rb:373:in `_run__109671231326174831__create__callbacks'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activesupport/lib/active_support/callbacks.rb:80:in `run_callbacks'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/callbacks.rb:306:in `create_record'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/timestamp.rb:57:in `create_record'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/persistence.rb:477:in `create_or_update'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/callbacks.rb:302:in `block in create_or_update'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activesupport/lib/active_support/callbacks.rb:373:in `_run__109671231326174831__save__callbacks'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activesupport/lib/active_support/callbacks.rb:80:in `run_callbacks'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/callbacks.rb:302:in `create_or_update'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/persistence.rb:106:in `save'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/validations.rb:51:in `save'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/attribute_methods/dirty.rb:32:in `save'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/transactions.rb:270:in `block (2 levels) in save'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/transactions.rb:326:in `block in with_transaction_returning_status'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:202:in `block in transaction'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:210:in `within_new_transaction'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:202:in `transaction'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/transactions.rb:209:in `transaction'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/transactions.rb:323:in `with_transaction_returning_status'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/transactions.rb:270:in `block in save'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/transactions.rb:281:in `rollback_active_record_state!'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/transactions.rb:269:in `save'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/lib/active_record/persistence.rb:37:in `create'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/test/cases/base_test.rb:611:in `test_unicode_column_name'
2) Failure:
BinaryTest#test_mixed_encoding [/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-aee1be6fe346/activerecord/test/cases/binary_test.rb:28]:
--- expected
+++ actual
@@ -1 +1 @@
-"いただきます!"
+"\xE3\x81\x84\xE3\x81\x9F\xE3\x81\xA0\xE3\x81\x8D\xE3\x81\xBE\xE3\x81\x99\xEF\xBC\x81"
3) Failure:
ColumnTestSqlserver::For datetime columns::with timestamps#test_0003_return :timestamp as a binaryish string [/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/test/cases/column_test_sqlserver.rb:197]:
Expected /\000/ to match "00000000000033ce".
4) Failure:
FinderTest#test_coerced_find_with_order_on_included_associations_with_construct_finder_sql_for_association_limiting_and_is_distinct [/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/test/cases/finder_test_sqlserver.rb:34]:
Expected: 2
Actual: 1
5) Failure:
ShowplanTestSqlserver::With SHOWPLAN_TEXT option#test_0001_use simple table printer [/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/test/cases/showplan_test_sqlserver.rb:37]:
make sure we do not showplan the sp_executesql
6) Failure:
UnicodeTestSqlserver::Testing unicode data#test_0001_insert and retrieve unicode data [/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/test/cases/unicode_test_sqlserver.rb:37]:
perhaps you are not using the utf8 odbc that does this legwork.
--- expected
+++ actual
@@ -1 +1 @@
-"一二34五六"
+"\xE4\xB8\x80\xE4\xBA\x8C34\xE4\xBA\x94\xE5\x85\xAD"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment