sqlserver_unicode_testing.rb

# Ruby: 1.8.7 (2008-08-11 patchlevel 72) [i686-darwin9]

>> @unicode_data = "\344\270\200\344\272\21434\344\272\224\345\205\255"
=> "一二34五六"
>> d = SqlServerUnicode.create!(:nvarchar => @unicode_data)
=> #<SqlServerUnicode id: 5, nchar: nil, nvarchar: "一二34五六", ntext: nil, ntext_10: nil, nchar_10: nil, nvarchar_100: nil>
>> d.reload.nvarchar
=> "一二34五六"
>> exit


# Ruby: 1.9.1p0 (2009-01-30 revision 21907) [i386-darwin9]

>> @unicode_data = "\344\270\200\344\272\21434\344\272\224\345\205\255"
=> "\xE4\xB8\x80\xE4\xBA\x8C34\xE4\xBA\x94\xE5\x85\xAD"
>> @unicode_data.encoding.name
=> "ASCII-8BIT"
>> data = SqlServerUnicode.create!(:nvarchar => @unicode_data)
=> #<SqlServerUnicode id: 6, nchar: nil, nvarchar: "\xE4\xB8\x80\xE4\xBA\x8C34\xE4\xBA\x94\xE5\x85\xAD", ntext: nil, ntext_10: nil, nchar_10: nil, nvarchar_100: nil>
>> data.reload.nvarchar
=> "\xE4\xB8\x80\xE4\xBA\x8C34\xE4\xBA\x94\xE5\x85\xAD"
>> puts data.reload.nvarchar
一二34五六
=> nil
>> data.reload.nvarchar.encoding.name
=> "ASCII-8BIT"
>>


# Ruby: 1.9.1p0 (2009-01-30 revision 21907) [i386-darwin9]
# Using a forced encoding on string literal 

>> @unicode_data = "\344\270\200\344\272\21434\344\272\224\345\205\255".force_encoding('UTF-8')
=> "一二34五六"
>> @unicode_data
=> "一二34五六"
>> data = SqlServerUnicode.create!(:nvarchar => @unicode_data)
=> #<SqlServerUnicode id: 7, nchar: nil, nvarchar: "一二34五六", ntext: nil, ntext_10: nil, nchar_10: nil, nvarchar_100: nil>
>> data.reload.nvarchar
=> "\xE4\xB8\x80\xE4\xBA\x8C34\xE4\xBA\x94\xE5\x85\xAD"
>> puts data.reload.nvarchar
一二34五六
=> nil
>> puts data.reload.nvarchar.encoding
ASCII-8BIT
=> nil
>> data.reload         
=> #<SqlServerUnicode id: 7, nchar: nil, nvarchar: "\xE4\xB8\x80\xE4\xBA\x8C34\xE4\xBA\x94\xE5\x85\xAD", ntext: nil, ntext_10: nil, nchar_10: nil, nvarchar_100: nil>
>> @unicode_data == data.reload.nvarchar
=> false
>> @unicode_data == data.reload.nvarchar
=> false
>> fd = data.nvarchar.force_encoding('UTF-8')
=> "一二34五六"
>> @unicode_data == fd
=> true
>> fd.encoding.name
=> "UTF-8"
>> fd.valid_encoding?
=> true
>>