freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Cannot send UTF-8 chars to MSSQL 2008

From: Daniel Fazekas <fdsubs AT t-online.hu>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Cannot send UTF-8 chars to MSSQL 2008
Date: Fri, 4 Jun 2010 10:41:53 +0200

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] Cannot send UTF-8 chars to MSSQL 2008, Niklas Lampén, 06/02/2010
- Re: [freetds] Cannot send UTF-8 chars to MSSQL 2008, Daniel Fazekas, 06/02/2010
  - Re: [freetds] Cannot send UTF-8 chars to MSSQL 2008, Niklas Lampén, 06/02/2010
    - Re: [freetds] Cannot send UTF-8 chars to MSSQL 2008, Craig A. Berry, 06/02/2010
      - Re: [freetds] Cannot send UTF-8 chars to MSSQL 2008, Niklas Lampén, 06/02/2010
      - Re: [freetds] Cannot send UTF-8 chars to MSSQL 2008, Niklas Lampén, 06/02/2010
        
        Re: [freetds] Cannot send UTF-8 chars to MSSQL 2008, Daniel Fazekas, 06/02/2010
        
        Re: [freetds] Cannot send UTF-8 chars to MSSQL 2008, Robert Gonzalez, 06/02/2010
        
        Re: [freetds] Cannot send UTF-8 chars to MSSQL 2008, Niklas Lampén, 06/04/2010
        
        Re: [freetds] Cannot send UTF-8 chars to MSSQL 2008, Niklas Lampén, 06/04/2010
        
        Re: [freetds] Cannot send UTF-8 chars to MSSQL 2008, Daniel Fazekas, 06/04/2010
        Re: [freetds] Cannot send UTF-8 chars to MSSQL 2008, Niklas Lampén, 06/04/2010
        Re: [freetds] Cannot send UTF-8 chars to MSSQL 2008, Daniel Fazekas, 06/04/2010
        Re: [freetds] Cannot send UTF-8 chars to MSSQL 2008, Niklas Lampén, 06/04/2010