Re: mssql and latin characters

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Jan 22, 2008 6:00 PM, Leticia Larrosa <leticia@xxxxxxxxxxxxxxxxxx> wrote:
>
> Thanks a lot Eric, I read those links and are really interesting.
>
> The solution of the problem was changing the "OEM character conversion"
> option of MSSql (see attached image) as Frank answer me in PHP-Windows list.
>
> Original answer of Frank:
>
> -----Original Message-----
> From: Frank M. Kromann [mailto:frank@xxxxxxxxxxxx]
> Sent: Tuesday, January 22, 2008 3:25 PM
> To: Leticia Larrosa
> Cc: php-windows@xxxxxxxxxxxxx
> Subject: Re: [PHP-WIN] mssql and latin characters
>
> Hi Leticia,
>
> MS SQL server comes with a set of client tools that allows you to specify
> the encoding. There is a checkbox in the Client Network Tool that allows
> you to enable/disable OEM character conversion. Flipping that for the alias
> you are using to connect to the database should fix the problem.
>
> Remember this must be done on the box where PHP is running if that's
> different from the SQL server box.
>
> - Frank
>
>
> Regards
> Leticia Larrosa
>
>
> -----Original Message-----
> From: Eric Butera [mailto:eric.butera@xxxxxxxxx]
> Sent: Monday, January 21, 2008 5:43 PM
> To: Leticia Larrosa
> Cc: php-general@xxxxxxxxxxxxx
> Subject: Re:  mssql and latin characters
>
> On Jan 20, 2008 9:53 PM, Leticia Larrosa <leticia@xxxxxxxxxxxxxxxxxx> wrote:
> > Hello
> >
> >
> >
> > I have a MSSql 2000 database that have stored data with the follow special
> > characters: ó, í, Ñ, á, é, ú.
> >
> > When I see the data through any MsSql Client I see exactly those
> characters.
> >
> >
> > The Collation of database is: SQL_Latin1_General_CP1_CI_AS
> >
> > I can't change the method of insert data in database.
> >
> >
> >
> > When I get (with MSSQL PHP extension) data that have some of those
> > characters, I get weird characters instead.
> >
> >
> >
> > For example:
> >
> > A data that in database appears as "Girón" is obtained by PHP as "Gir¢n"
> >
> >
> >
> > The problem with the encoding of browser is discarded, because wherever I
> > saw the data appears with weird characters.
> >
> >
> >
> > The code I use to get the data is:
> >
> > <?php
> >
> > mssql_connect('server','user','pass');
> >
> > mssql_select_db('db');
> >
> >
> >
> > $r = mssql_query("select some_column from some_table");
> >
> > $d = mssql_fetch_assoc($r);
> >
> >
> >
> > echo $d['some_column'];
> >
> > ?>
> >
> >
> >
> > My PHP is 4.4.3, and my SO is XP.
> >
> >
> >
> > Other people ask the same as I'm and get no answer proper are:
> >
> >
> >
> <http://www.psicofxp.com/forums/desarrollo-web.264/226703-php-mssql-y-acento
> > s.html>
> >
> http://www.psicofxp.com/forums/desarrollo-web.264/226703-php-mssql-y-acentos
> > .html
> >
> >  <http://www.bdat.net/cuestiones_php/php3/0702.html>
> > http://www.bdat.net/cuestiones_php/php3/0702.html
> >
> >
> >
> <http://www.forosdelweb.com/f18/problemas-con-caracteres-especiales-acentos-
> > php-mssql-server-364345/>
> >
> http://www.forosdelweb.com/f18/problemas-con-caracteres-especiales-acentos-p
> > hp-mssql-server-364345/
> >
> >  <http://markmail.org/message/7rksvz44sj2te5sl>
> > http://markmail.org/message/7rksvz44sj2te5sl
> >
> >  <http://www.phpbuilder.com/board/archive/index.php/t-10208269.html>
> > http://www.phpbuilder.com/board/archive/index.php/t-10208269.html
> >
> >
> >
> >
> >
> > Thanks in advanced.
> >
> > Leticia Larrosa
> >
> >
> > __________________________________________
> >
> > Participe en Universidad 2008.
> > 11 al 15 de febrero del 2008.
> > Palacio de las Convenciones, Ciudad de la Habana, Cuba
> > http://www.universidad2008.cu
>
> Hi Leticia,
>
> You should be using utf-8, really.  What you're dealing with are
> encoding issues.  8bit character sets just can't hold all known
> characters, so people invented lots of them to make up for this.  See
> my links below for an in depth look.  Maybe, just maybe, we can trick
> the browser into showing your text right.  Below the header and the
> meta tag are the key parts to it.
>
> Try this:
> <?php
> header("Content-Type: text/html; charset=iso-8859-1");
> ?>
> <html>
> <head>
> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
> </head>
> <body>
> i18n ftw!
> </body>
> </html>
>
> You might also take a look at:
> http://www.microsoft.com/sql/technologies/php/default.mspx
>
> Also please read this: http://www.phpwact.org/php/i18n/charsets.
>
> And this too: http://talks.php.net/show/wereldveroverend-ffm2004
>
> Have fun!
>
>
> __________ NOD32 2808 (20080120) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>
>
> __________________________________________
>
> Participe en Universidad 2008.
> 11 al 15 de febrero del 2008.
> Palacio de las Convenciones, Ciudad de la Habana, Cuba
> http://www.universidad2008.cu

Thank you for posting the answer to the list for archives!

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux