Skip to Content.
Sympa Menu

freetds - RE: [freetds] PHP: Inserts with Unicode

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] PHP: Inserts with Unicode
  • Date: Wed, 21 Jan 2004 17:49:19 +0100

>
> Hi everone,
>
> I use RedHat 8.0, MSSQL2000, PHP4.3.3 and FreeTDS (version 8.0; client
> charset: UTF-8).
>

I suppose you are using 0.62 or 0.62.1 (version 8.0 specify TDS protocol
version, not FreeTDS version).

> I can read and display all NTEXT and NVARCHAR-Fields from
> MSSQL correctly.
> But if I try to write the read data into the database I get
> always the parse
> error "Unclosed quotation mark...".
>
> The Insert looks like...
>
> db("INSERT INTO table (test) (N'".addslashes($read)."')");
>
> If I echo the SQL and use it in the Enterprise Manager
> everything works
> correctly. Any clues?
>

If you configured correctly connection (you should force UTF-8) you
should be able to insert any character you want. I think your pages are
configured with UTF-8 charset either. Can you post an example of query
you are trying to execute? I don't think you have problems if $read ==
'foo'...

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page