ActiveRecord Sql Server中文问题2
1 下面代码在netbean下执行有问题,因为netbean的文件保存格式是utf-8.会报错存在多字节字符。
view sourceprint?1 搞不明白。但如果直接存为ANSI即一切正常。记之
view sourceprint?01 # coding : gb2312
02 require "rubygems"
03 gem 'activesupport', '=2.3.8'
04 require "active_record"
05 #require 'odbc_utf8'
06 require 'odbc'
07 require 'iconv'
08
09 conv=Iconv.new('GB2312','UTF-8')
10
11
12 ActiveRecord::Base.establish_connection(
13 :adapter => "sqlserver",
14 :mode=>"odbc",
15 :dsn=>"localhost",
16 :database=> "jkdb_sg",
17 :username => "sa",
18 :password => "123",
19 :encoding=>"gb2312"
20 )
21
22 =begin
23 class MyModule < ActiveRecord::Base
24
25 set_table_name "Module"
26 set_primary_keys :RoadNo, :ModuleNo
27
28 end
29 =end
30
31
32 class Road < ActiveRecord::Base
33 set_table_name "Road"
34 set_primary_key "RoadNo"
35 end
36
37
38 Road.all().each do |r|
39 #puts conv.iconv(r.RoadName)
40 puts r.RoadName
41 end
42
43 =begin
44 r=Road.find(46)
45 r.RoadName='广珠西'
46 r.save
47 =end
48
49
50
51
52
53 puts "done"
54 puts "完成"