freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] PHP MSSQL throught freetds failing inserts when there any word with a acent
- 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: Mon, 17 Mar 2003 00:54:28 -0800 (PST)
Hi, boys:
This is a really problem for me, any time a user type
a word with acent everything ""PUM"", and I have
tested all the charsets, this is the output of my
locale in RedHat 8.0...
LANG=es_ES.UTF-8
LC_CTYPE="es_ES.UTF-8"
LC_NUMERIC="es_ES.UTF-8"
LC_TIME="es_ES.UTF-8"
LC_COLLATE="es_ES.UTF-8"
LC_MONETARY="es_ES.UTF-8"
LC_MESSAGES="es_ES.UTF-8"
LC_PAPER="es_ES.UTF-8"
LC_NAME="es_ES.UTF-8"
LC_ADDRESS="es_ES.UTF-8"
LC_TELEPHONE="es_ES.UTF-8"
LC_MEASUREMENT="es_ES.UTF-8"
LC_IDENTIFICATION="es_ES.UTF-8"
LC_ALL=
Is there any solution for RedHat 8.0 about this, or
any way that freetds ignore this words or something...
Aliet
--- "James K. Lowden" <jklowden AT schemamania.org>
wrote:
> 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
> _______________________________________________
> 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] Strange assert,
Frediano Ziglio, 03/15/2003
-
Re: [freetds] Strange assert,
James K. Lowden, 03/15/2003
- Re: [freetds] Strange assert, James K. Lowden, 03/15/2003
-
[freetds] PHP MSSQL throught freetds failing inserts when there any word with a acent,
Aliet Santiesteban Sifontes, 03/15/2003
-
Re: [freetds] PHP MSSQL throught freetds failing inserts when there any word with a acent,
James K. Lowden, 03/15/2003
-
Re: [freetds] PHP MSSQL throught freetds failing inserts when there any word with a acent,
Aliet Santiesteban Sifontes, 03/15/2003
-
Re: [freetds] PHP MSSQL throught freetds failing inserts when there any word with a acent,
Aliet Santiesteban Sifontes, 03/15/2003
-
Re: [freetds] PHP MSSQL throught freetds failing inserts when there any word with a acent,
James K. Lowden, 03/15/2003
- Re: [freetds] PHP MSSQL throught freetds failing inserts when there any word with a acent, Frediano Ziglio, 03/16/2003
- Re: [freetds] PHP MSSQL throught freetds failing inserts when there any word with a acent, Aliet Santiesteban Sifontes, 03/17/2003
- Re: [freetds] PHP MSSQL throught freetds failing inserts when there any word with a acent, Aliet Santiesteban Sifontes, 03/21/2003
-
Re: [freetds] PHP MSSQL throught freetds failing inserts when there any word with a acent,
James K. Lowden, 03/15/2003
-
Re: [freetds] PHP MSSQL throught freetds failing inserts when there any word with a acent,
Aliet Santiesteban Sifontes, 03/15/2003
-
Re: [freetds] PHP MSSQL throught freetds failing inserts when there any word with a acent,
Aliet Santiesteban Sifontes, 03/15/2003
-
Re: [freetds] PHP MSSQL throught freetds failing inserts when there any word with a acent,
James K. Lowden, 03/15/2003
- <Possible follow-up(s)>
-
Re: [freetds] Strange assert,
Rusty Wright, 03/17/2003
- Re: [freetds] Strange assert, Frediano Ziglio, 03/17/2003
- RE: [freetds] Strange assert, Lowden, James K, 03/17/2003
- Re: [freetds] Strange assert, Rusty Wright, 03/18/2003
-
Re: [freetds] Strange assert,
James K. Lowden, 03/15/2003
Archive powered by MHonArc 2.6.24.