Posted by deciacco on 07/11/06 16:11

That did it!!!

I don't quite understand how it works or why I needed to use the php
function putenv() but it works...

I added the line marked by -->

[MyServer2k]
host = 192.168.0.1
port = 1433
tds version = 8.0
--> client charset = UTF-8

and I went back to using PEAR:

$dbh = DB::connect("mssql://sa:password@MyServer2K/northwind");

Thank you!!

Chung Leong wrote:
> deciacco wrote:
> > Discovered more information:
> >
> > I changed my code from using
> > $dbh = DB::connect("mssql://sa:password@192.168.0.1/northwind"); to
> > simply using the freetds connection
> >
> > putenv("FREETDSCONF=/etc/freetds.conf");
> > $db=mssql_connect("MyServer2k","sa","password");
> >
> > (freetds.conf setting)
> > [MyServer2k]
> > host = 192.168.0.1
> > port = 1433
> > tds version = 8.0
> >
>
> Try adding the line
>
> client charset = cp1250
>
> or
> client charset = utf8

• Next in forum: Re: Dynamic data exchange between JavaScript and PHP
• Prev in forum: Sort of dumb question on multi-page output?
• Thread view: Re: Php retreiving data from mssql and special characters

[Reply to this message]