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:27:37 -0800 (PST)

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




Archive powered by MHonArc 2.6.24.

Top of Page