PHP MSSQL non english characters, problems with freetds on linux

[hassanali20]

I've surfed this forum and found one thread which was talking about the same problem i've, but it didn't help in my situation.
http://www.thescripts. com/forum/thread510563.ht ml

I could connect to MSSQL server using freetds 8.0 and able to run queries to MSSQL server, but the query doesn't fetch anything when it runs on a column having datatype as VARCHAR having special character as in <méxico> (note the second character) the acute accent.

i've been trying to search a solution but no luck so far. I changed my datatype to nvarchar also, no change.

below is the TDSDUMP
------------------------------
util.c:288:Star ting log file for FreeTDS 0.64
on 2007-11-28 03:20:06 with debug flags 0x4fff.
config.c:158:At tempting to read conf files.
config.c:259:.. .$FREETDSCONF not set. Trying $FREETDS/etc.
config.c:275:.. .$FREETDS not set. Trying $HOME.
config.c:202:Fo und conf file '/usr/local/freetds/etc/freetds.conf' (default). Reading section 'MyServer2k'.
config.c:333:Lo oking for section global.
config.c:390:.. . Found section global.
config.c:393:Go t a match.
config.c:413:op tion = 'tds version' value = '4.2'.
config.c:413:op tion = 'client charset' value = 'UTF-8'.
config.c:457:td s_config_login: client charset is UTF-8.
config.c:413:op tion = 'text size' value = '64512'.
config.c:390:.. . Found section jdbc.
config.c:390:.. . Found section jdbc_42.
config.c:390:.. . Found section mypool.
config.c:390:.. . Found section myserver2k.
config.c:333:Lo oking for section MyServer2k.
config.c:390:.. . Found section global.
config.c:390:.. . Found section jdbc.
config.c:390:.. . Found section jdbc_42.
config.c:390:.. . Found section mypool.
config.c:390:.. . Found section myserver2k.
config.c:393:Go t a match.
config.c:413:op tion = 'host' value = '<SERVER HOST NAME>'.
config.c:440:Fo und host entry <SERVER HOST NAME>.
config.c:443:IP addr is <IP ADDRESS>.
config.c:413:op tion = 'port' value = '<SQL PORT>'.
config.c:413:op tion = 'tds version' value = '8.0'.
config.c:206:.. .Success.
+++++++++++++++ +++++++++++++++

I've also added the charset UTF-8 in freetds conf file, still no change.

I would be really greatful if someone please help me to get around this.

Thanks everyone in advance.

Best Regards
Hassan Ali