Skip to Content.
Sympa Menu

freetds - Re: [freetds] mssql_connect : Unable to connect to server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Pedro Barbosa <pbarbosa AT inescporto.pt>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] mssql_connect : Unable to connect to server
  • Date: Tue, 08 Nov 2005 11:44:42 +0000

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







Archive powered by MHonArc 2.6.24.

Top of Page