php-i18n Digest 22 Jan 2008 19:27:03 -0000 Issue 381
Topics (messages 1146 through 1148):
mssql and latin characters
1146 by: Leticia Larrosa
Re: intl extension
1147 by: David M.
1148 by: Stanislav Malyshev
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
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 cant 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 OS is XP.
Other people ask the same as Im and get no answer proper are:
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.forosdelweb.com/f18/problemas-con-caracteres-especiales-acentos-p
hp-mssql-server-364345/
http://markmail.org/message/7rksvz44sj2te5sl
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
--- End Message ---
--- Begin Message ---
Stanislav Malyshev wrote:
I have released a beta version of the intl extension (ICU
implementation). It is documented here:
http://docs.php.net/manual/en/book.intl.php
and can be installed either by downloading package from PECL:
http://pecl.php.net/package/intl
or just by running "pecl install intl".
Please try it!
This is great to have! :) As a developer writing considerable amounts of
code that does this kind of stuff, it is nice to know that we can use
this as an alternative to our own PHP based implementation.
P.S.
Any hope on getting case folding in there? ICU supports it :) It is
useful from a security standpoint (making sure that usernames cannot be
confused with others, etc.) If you do not have the time, I suppose I
could make a patch for it...
--- End Message ---
--- Begin Message ---
Any hope on getting case folding in there? ICU supports it :) It is
We plan to have a bunch of stuff dealing with unicode characters later,
but not in the first release. First release is to deal mostly with
locale-dependent stuff (though not exclusively). So there's definitely
hope, but probably also some waiting involved :)
--
Stanislav Malyshev, Zend Software Architect
[EMAIL PROTECTED] http://www.zend.com/
(408)253-8829 MSN: [EMAIL PROTECTED]
--- End Message ---
