Problem With TCL

Hi all,

My name is Paulo and I'm trying to make a tcl that allows my IRC Bot 
connects to my IRC Services (gnuworld) PostgreSQL database and get 
information about our channels.

I thought it was working fine, until I tryed to find information about a 
channel called #espa�a. For our surprise the bot told "No records found for 
#espa�a". So I got curious and made other tests... it doesn't works for any 
channels with chars like � in the name.

I already tryed to google it, but (may be my bad, anyway, ) I didn't find 
much.

Could anyone help me please?

My TCL code that checks information about that channels is:

bind pub $cservice(flags) ${cservice(char)}info pub.info:cservice
proc pub.info:cservice {nick uhost hand chan rest} {   global cservice   if {[lindex $rest 0] == ""} {       putserv
"Notice$nick :Command should be: \002$cservice(char)purge 
 
\<#ChannelName\>\002"       if {$cservice(dchan) != ""} {           putserv "PRIVMSG $cservice(dchan) 
:\002\[\002CSC\002/\002Debug\002\]\002 Failed attemp to get \002PURGE\002 
information from \002${nick}\002!${uhost} ($hand). Reason: \002Wrong Command 
Syntax\002"       }       return 0   }   if {![string match "#*" [lindex $rest 0]]} {       putserv "NOTICE $nick
:\002[stringtoupper [lindex $rest 0]]\002 
 
doesn't seems to be a valid Channel Name!"       return 0   }   set conexao [pg_connect $cservice(database) -host
$cservice(host)-port 
 
$cservice(port)]   putserv "NOTICE $nick :Please wait while I get \002[string toupper 
$cservice(command_purge)]\002 information about channel \002[string tolower 
[lindex $rest 0]]\002"   set query [pg_exec $conexao "SELECT * FROM channels WHERE 
lower(name)='[string tolower [lindex $rest 0]]'";]   if {[pg_result $query -numTuples] > 0} { putserv "NOTICE $nick
:Results
 
Found" } else { putserv "NOTICE $nick :No records found" }   pg_disconnect $conexao
}



Well... another interesting notes: I can see information about that kind of 
channel name using a third  part PHP nterface. Current server encoding is 
'SQL_ASCII'. (I'm not familiar with that... but some guys told that it may 
be usefull).

Thanks for your time guys. Hugs.

Paulo

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/