freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
[freetds] PHP: Inserts with Unicode,
Marco Brinkmann, 01/21/2004
- Re: [freetds] PHP: Inserts with Unicode, Daniel Fazekas, 01/21/2004
- <Possible follow-up(s)>
- RE: [freetds] PHP: Inserts with Unicode, Lowden, James K, 01/21/2004
- RE: [freetds] PHP: Inserts with Unicode, ZIGLIO, Frediano, VF-IT, 01/21/2004
Archive powered by MHonArc 2.6.24.