Re: Cannot send UTF-8 chars to MSSQL 2008

On Jun 4, 2010, at 07:57, Niklas Lampén wrote:

>>> 1> UPDATE Mod_Texts SET ContentData='foo Найти' WHERE ContentId=6824;
>> Is that field even capable of storing Cyrillic letters?
> Yes, it is. The field is NVARCHAR and if I use Microsoft SQL Server Management Studio, I can insert that string in it and fetch it correctly with FreeTDS.

Try inserting it like this instead:

ContentData=N'foo Найти'

Note the extra N before the quotes.

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds