FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

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