metaskills (owner)

Revisions

gist: 111719 Download_button fork
public
Public Clone URL: git://gist.github.com/111719.git
Embed All Files: show embed
fixed_sqlserver_adapter.rb #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

# Ruby: 1.9.1p0 (2009-01-30 revision 21907) [i386-darwin9]
# Using a both types of encoded string literals
 
>> ud1 = "\344\270\200\344\272\21434\344\272\224\345\205\255"
=> "\xE4\xB8\x80\xE4\xBA\x8C34\xE4\xBA\x94\xE5\x85\xAD"
>> d1 = SqlServerUnicode.create!(:nvarchar => ud1)
=> #<SqlServerUnicode id: 12, nchar: nil, nvarchar: "一二34五六", ntext: nil, ntext_10: nil, nchar_10: nil, nvarchar_100: nil>
>> d1.reload.nvarchar
=> "一二34五六"
>> 
?> ud2 = "\344\270\200\344\272\21434\344\272\224\345\205\255".force_encoding('UTF-8')
=> "一二34五六"
>> d2 = SqlServerUnicode.create!(:nvarchar => ud2)
=> #<SqlServerUnicode id: 13, nchar: nil, nvarchar: "一二34五六", ntext: nil, ntext_10: nil, nchar_10: nil, nvarchar_100: nil>
>> d2.reload.nvarchar
=> "一二34五六"