freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: Robert Gonzalez <robert AT robert-gonzalez.com>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Cannot send UTF-8 chars to MSSQL 2008
Date: Wed, 2 Jun 2010 10:12:01 -0700

Are you sure PHP is handling the charset correctly? Just a thought, if PHP
is doing something to it before it ever gets handed off to the database then
it would make sense that the DB is not getting it properly.

On Wed, Jun 2, 2010 at 7:32 AM, Daniel Fazekas <fdsubs AT t-online.hu> wrote:

> On Jun 2, 2010, at 15:16, Niklas Lampén wrote:
>
> > 1> UPDATE Mod_Texts SET ContentData='foo Найти' WHERE ContentId=6824;
> > 2> SELECT ContentData FROM Mod_Texts WHERE ContentId=6824;
> > 3> GO
> > ContentData
> > foo ?????
>
> Is that field even capable of storing Cyrillic letters?
> It's possible it's not an NTEXT field and the server isn't set to use a
> Cyrillic single-byte character set.
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>

--
Robert Gonzalez
http://www.robert-gonzalez.com
http://twitter.com/RobertGonzalez
http://www.linkedin.com/in/robertanthonygonzalez

[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