Sha256: eeb2af4decff90d70f6fccf8a636cbd1985d70d783315b41ab577eef86bc549f
Contents?: true
Size: 1.27 KB
Versions: 21
Compression:
Stored size: 1.27 KB
Contents
require 'cases/sqlserver_helper'
class UnicodeTestSqlserver < ActiveRecord::TestCase
context 'Testing basic saves and unicode limits' do
should 'save and reload simple nchar string' do
assert nchar_data = SqlServerUnicode.create!(:nchar => 'A')
assert_equal 'A', SqlServerUnicode.find(nchar_data.id).nchar
end
should 'save and reload simple nvarchar(max) string' do
test_string = 'Ken Collins'
assert nvarcharmax_data = SqlServerUnicode.create!(:nvarchar_max => test_string)
assert_equal test_string, SqlServerUnicode.find(nvarcharmax_data.id).nvarchar_max
end if sqlserver_2005?
should 'enforce default nchar_10 limit of 10' do
assert_raise(ActiveRecord::StatementInvalid) { SqlServerUnicode.create!(:nchar => '01234567891') }
end
should 'enforce default nvarchar_100 limit of 100' do
assert_raise(ActiveRecord::StatementInvalid) { SqlServerUnicode.create!(:nvarchar_100 => '0123456789'*10+'1') }
end
end
context 'Testing unicode data' do
setup do
@unicode_data = "一二34五六"
end
should 'insert into nvarchar field' do
assert data = SqlServerUnicode.create!(:nvarchar => @unicode_data)
assert_equal @unicode_data, data.reload.nvarchar
end
end
end
Version data entries
21 entries across 21 versions & 5 rubygems