Robert Gonzalez | 2 Jun 2010 19:12
Favicon

Re: Cannot send UTF-8 chars to MSSQL 2008

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
_______________________________________________
(Continue reading)

Niklas Lampén | 4 Jun 2010 08:03
Picon

Re: Cannot send UTF-8 chars to MSSQL 2008

> 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.

Well, no. But it seems to me that data is converted to ISO_1, which is because of what MSSQL Server tells to
FreeTDS. I'm hoping to get around this somehow.

Niklas

Gmane