[freetds] mssql_connect : Unable to connect to server

Pedro Barbosa pbarbosa at inescporto.pt
Tue Nov 8 06:44:42 EST 2005


i'm sorry but i dont think i understand.
What i did was add in locales.conf

[pt_PT]
        date format = %d/%m/%Y %H:%M
        language = Portuguese
        char set = iso_1

and in freetds.conf i have:
[server]
host = ip
port =1433
tds version = 8.0
client charset = pt_PT

when i try to access from [freetds]/bin/tsql ....
it says :
locale is "pt_PT.UTF-8"
locale charset is "UTF-8"

but problems like é ou ç ão tipical portuguese caracters dont appear in 
the correct format.

What else do i have to do?

Thanks
Pedro Barbosa





James K. Lowden wrote:

>>Frediano Ziglio wrote:
>>    
>>
>>>Il giorno ven, 04/11/2005 alle 16.18 +0000, Pedro Barbosa ha scritto:
>>>      
>>>
>>>>By the way dows anyone knows how to solve the problem of encoding.
>>>>        
>>>>
>>>when  >i do a select in a table i get the tipical portuguese caracters
>>>like a  >square. how can i solve this?
>>>
>>>You have to use a client encoding that is compatible.
>>>
>>>      
>>>
>Pedro Barbosa wrote:
>  
>
>>freddy  can you be a litlle more specific?
>>i assume if any change needs to be done is is freetds.conf, but what do 
>>i have to had ?
>>Do i have to specify something to the configuration on my server like 
>>"unicode= pt" ????
>>    
>>
>
>Frediano means your encodings have to match. 
>
>The "client charset" in freetds.conf should match the character set on the
>client indicated by locale(1).  
>
>HTH.  
>
>--jkl
>  
>
>_______________________________________________
>FreeTDS mailing list
>FreeTDS at lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>
>  
>



More information about the FreeTDS mailing list