freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] PHP: Inserts with Unicode

From: "Marco Brinkmann" <marco_brinkmann AT gmx.net>
To: freetds AT lists.ibiblio.org
Subject: [freetds] PHP: Inserts with Unicode
Date: Wed, 21 Jan 2004 09:25:33 +0100 (MET)

Hi everone,

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

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?

Thanks,

mabrin

--
+++ GMX - die erste Adresse für Mail, Message, More +++
Bis 31.1.: TopMail + Digicam für nur 29 EUR http://www.gmx.net/topmail

[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