FreeTDS Development Group

["James K. Lowden" <jklowden AT schemamania.org>]

On Sat, 15 Mar 2003 18:41:59 -0800 (PST), Aliet Santiesteban Sifontes
<alietss AT yahoo.com> wrote:
> Hi James this is my log file... I can see that the
> charset is empty...How could I know my charset??
> And how is the sintaxis to do it in the freetds.conf
> file. 

        client charset = ISO-8859-1

should do the trick.  

Oh oh oh.  Red Hat 8.0 you say?  What does locale(1) return for you?  

I think RH8 comes set up for UTF-8 out of the box.  This could  be tricky,
because I don't think FreeTDS or PHP are completely ready for UTF-8.  

--jkl



> 
> Starting log file with debug level 99.
> 2003-03-15 21:36:29.744561 iconv will convert
> client-side data to the "" character set
> 2003-03-15 21:36:29.744779 Connecting addr
> 172.16.30.35 port 1433 with TDS version 7.0
> 2003-03-15 21:36:29.745280 inside
> tds_process_login_tokens()
> Received header @ 2003-03-15 21:36:29.746655
> 
>                         Any ideas, Aliet
> --- Aliet Santiesteban Sifontes <alietss AT yahoo.com>
> wrote:
> > Hi James, and thank's for answering:
> > I saw in locales.conf a line that says char_set =
> > iso_1
> > Where exactly do I have to write the charset in my
> > configuration, is there any documentation about
> > this??
> >                                   Thank's Aliet
> > --- "James K. Lowden" <jklowden AT schemamania.org>
> > wrote:
> > > On Sat, 15 Mar 2003 13:01:51 -0800 (PST), Aliet
> > > Santiesteban Sifontes
> > > <alietss AT yahoo.com> wrote:
> > > > Hi all the freetds people, I'm testing a lot the
> > > new
> > > > MSSQL support in PHP-4.3.1 freetds-0.61, on a
> > > RedHat
> > > > 8.0 box, and I must say that everything is
> > pretty
> > > > well, but I'm having a problem when I'm doing a
> > > insert
> > > > using as values any word with a acent, example
> > > 'Jos_'
> > > > , acents are used in sapanish language a lot,
> > when
> > > I
> > > > make the insert I get this error...
> > > > 0: Unclosed quotation mark before the character
> > > string ')'.
> > > 
> > > Aliet, 
> > > 
> > > Glad things are going "pretty well".  :-)
> > > 
> > > To handle non-ASCII characters (>128), two things
> > > have to be in place:
> > > your local character set has to be specified in
> > > freetds.conf, and FreeTDS
> > > has to be compiled with the iconv library.  The
> > > error you're getting
> > > indicates to me that FreeTDS isn't converting
> > > properly, probably because
> > > of the client character set.  
> > > 
> > > Try your query with tsql, and have a look at the
> > > output of the TDSDUMP log
> > > file.  The top of the log should show what
> > character
> > > set is being used and
> > > whether or not libiconv is happy with it.  
> > > 
> > > --jkl