Hi Fred, I appreciate the reply. We are using SQL Server 2005 and our database record looks like this:
name cast(name as varbinary) Café Records 0x436166E9205265636F726473 If I use the ruby console and print each byte, I get this. Must be at better way to show the byte stream in ruby 1.8.6 than this... >> l.name[0] => 67 >> l.name[1] => 97 >> l.name[2] => 102 >> l.name[3] => 233 >> l.name[4] => 32 The database table defines the name column as varchar(255). I cannot find the column level encoding but I read (http://books.google.com/books?id=_8t73M1r71sC&pg=PA418&lpg=PA418&dq=encoding+sql+server+2005&source=bl&ots=hT6RZJyXl-&sig=KzP2kG73Md7-N5oZviZZ9Xie2PY&hl=en&ei=wcuASu2AIo3gswPvgu32CA&sa=X&oi=book_result&ct=result&resnum=8#v=onepage&q=&f=false) that SQL server 2005 by default uses Unicode ( doesn't say which Unicode though. I believe when you specify a column as nvarchar then it default to UCS-2? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
