Re: DBI + SQL Server AND Special Character


XP is just a number
	PerlMonks

Re: DBI + SQL Server AND Special Character

by joe++ (Friar)

on Nov 05, 2002 at 15:38 UTC ( [id://210480]=note: print w/replies, xml )

Need Help??

in reply to DBI + SQL Server AND Special Character

Hi Zitoune,

You should look into Free TDS and DBD::Sybase - see Re: SQL Server freeTDS walkthrough?
The character set returned by SQL Server is UTF-8, so anything that is not ASCII is not represented by a single byte - you can convert these to ISO-8859-1 or something else if this doen't work for you.

Update: forgot to mention that this assumes you're on some Un*x platfom (I implemented this on Sun Solaris some 2 years ago). For Windows you may be better off using ODBC.

--
Cheers, Joe