Hi there,
I'm trying to test the new Unicode support in Rails 1.2 RC1 with a
Microsoft SQL Server 2000 database. If I use the out-of-the-box
configuration, I get UTF8 support in Rails. I can connect up to a SQL
Server, using nvarchar columns, and a scaffolded demo will save and
display data correctly.
However since SQL Server isn't using UTF8 (it's UTF16 I believe), if I
look at the actual data in the database through a 3rd party tool like
Query Analyzer, the data is mangled. It appears that the database layer
is simply storing the UTF8 in byte-pairs. This will mean that non-exact
where clauses won't work, database ordering will be wrong, 3rd party
tools won't be able to query etc.
So am I doing something wrong or is this how Rails is supposed to work
with SQL Server? I realise that Oracle/MySQL both support UTF8 and so
won't have this problem, but what about SQL Server?
Thanks in advance, and apologies if this is the wrong list.
Jon Rowland
