Rails - Sep 2006 - Sql server and varbinary columns

anyone know how to pass a file to a varbinary column right now I''m
trying this.

view:
<% file_field ''stored_files'', ''tmp_file'',
:enctype =>
''application/binary'' %>

controller:
 params[:stored_files][:file] = params[:stored_files][:tmp_file].read
 params[:stored_files].delete(''tmp_file'')
 #then regular controller create stuff new save etc...

This causes active record to try and create the varbinary object using
a sql INSERT statement:

  PredefinedTestParameter Create (0.000000)   DBI::DatabaseError: 22005
(257) [unixODBC][FreeTDS][SQL Server]Implicit conversion from data type
varchar(max) to varbinary(max) is not allowed. Use the CONVERT function
to run this query.: INSERT INTO predefined_test_parameter
([numeric_value], [data_type], [date_time_value], [object_value],
[param_name], [step_id], [string_value], [sort], [test_run_id],
[test_session_id]) VALUES(NULL, ''File'', NULL,
''%PDF-1.2%00%âaIO%00%01202 0 obj%00<< %00/Linearized 1 %00/O 205
%00/H
[ 1462 229 ] %00/L 35078 %00/E 12235 %00/N 1 %00/T 30919 %00>>
%00endobj%00 xref%00202 32 %000000000016 00000 n%00%010000000991 00000
n%00%010000001324 00000n%00%010000001691 000'')

this produces an error from sqlserver because you are trying to pass a
varchar to a varbinary.  any idea how this is supposed to work on ruby
on rails?  My application server is on linux, does it need to be on
windows to get this to work?


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---