Forums | Admin

Discussion Forums: open-discussion

Start New Thread Start New Thread
Message: 26755
BY: Mark Fraser (mark100net)
DATE: 2007-08-14 16:08
SUBJECT: MS SQL Server column type problem

 

I am using ADO.rb and MSSQL.rb to connect to MS SQL Server 2000 from a rails application.

I have had no problems other than the following:

The (legacy) MS SQL database has several fields of 'nchar' type. All of these, save one, gets mapped to a Ruby string by AR.

The one field I am having trouble with is also an nchar and there is no apparent difference between the other nchar fields. However AR is mapping it to a "Fixnum" type. The field contains 32 character guids. This creates problems because the to_s method converts them into a numeric value.

Does anyone have any suggestions on what the problem (and solution) could be?

Thanks,

Mark


Thread View

Thread Author Date
MS SQL Server column type problemMark Fraser2007-08-14 16:08
      RE: MS SQL Server column type problemMark Fraser2007-08-14 16:56

Post a followup to this message