Skip to Content.
Sympa Menu

freetds - Re: [freetds] PHP MSSQL throught freetds failing inserts when there any word with a acent

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Aliet Santiesteban Sifontes <alietss AT yahoo.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] PHP MSSQL throught freetds failing inserts when there any word with a acent
  • Date: Sat, 15 Mar 2003 18:41:59 -0800 (PST)

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. Here the log..

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
> >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Web Hosting - establish your business online
> http://webhosting.yahoo.com
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds


__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com




Archive powered by MHonArc 2.6.24.

Top of Page