php-i18n Digest 12 Mar 2003 13:32:26 -0000 Issue 159
Topics (messages 497 through 500):
Re: PHP, Unicode, SAPdb
497 by: Gary Ross
498 by: Nino Katic
499 by: David Powers
Encoding Problems
500 by: Jürgen Hoffmann
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 ---
I think it is incorrect to say that MySQL doesn't support Unicode
although it's support may not be complete yet. I have a multilingual
site that has database information in Korean, Japanese and Chinese
without problems. I just put utf-8 encoding and it works fine, make
sure mysql is compiled with the language complex flag.
Gary
On Sunday, March 9, 2003, at 02:16 am, Nino Katic wrote:
Hi,
I'm new to this list, and I'm also new to i18n. I'm developing some
web site
and i want to make it i18n. Basicly I want user to have all their
country
specific charaters displayed correclty. Here, there are two problems.
One is
dealing with DB and the other with PHP. Firstly I tried with MySQL but
when
I saw it doesn't support unicode i gave up and switched to SAP db. SAP
db
has unicode support BUT i can't make it sort country specific
characters
right. I'm told that this is not possible to do on a server side and
to make
it on client. Is this right? Secondly, i don't know what i need to do
to
display that unicode data from SAP db using php? I tried playing a
liitle
with those mb_string functions and settings, but unsuccesfull. For
example
if i want to echo the word begining with some croatian specific
characters
it displayes me "k" ??? So, my general question would be how to deal
with
that display from php, and how with sort of country specific
characters?
Tnx.
Nino
--
PHP Internationalization Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Gary Ross wrote:
> I think it is incorrect to say that MySQL doesn't support Unicode
> although it's support may not be complete yet. I have a multilingual
> site that has database information in Korean, Japanese and Chinese
> without problems. I just put utf-8 encoding and it works fine, make
> sure mysql is compiled with the language complex flag.
> Gary
How do you sort country specific characters? For example i have to start
mysql using croat charset to do the sorting of croatian characters right.
Changing the charset can not be be done while mysql is running. Using UTF-8
to store characters and default iso-8859-1 mysql encoding doesn't sort
characters correctly either.
Nino
--- End Message ---
--- Begin Message ---
Nino Katic wrote:
||
|| How do you sort country specific characters? For example i have to
|| start mysql using croat charset to do the sorting of croatian
|| characters right. Changing the charset can not be be done while
|| mysql is running. Using UTF-8 to store characters and default iso-
|| 8859-1 mysql encoding doesn't sort characters correctly either.
The ability to use multiple character sets in MySQL will not be
available until version 4.1. At the moment, you have to run multiple
instances of the server if you want to use different character sets for
sorting purposes. You can store different character sets side by side.
It's the sorting that cannot yet be configured on a column or table
basis.
David Powers
--- End Message ---
--- Begin Message ---
Hi All,
I have a major encoding with my mysql driven php app. I have developed
my Application on Windows and deployed it on a Linux Box running mysql
and apache.
Now I have a problem with my UTF-8 Characters. Which I store in my mysql
database fine. But when displayed the utf-8 characters are displayed as
garbage in the Internet Explorer 6. When I change the Page Encoding in
the Browser explicitely everything is fine.
I have set default_charset = "utf-8" in php.ini
Runtime Environment:
Server:
Debian GNU/Linux Woody
Apache 1.3.26
Php4
In the <head> section of each php i have set the encoding explicitely as
such: <meta http-equiv="content-type" content="text/html;
charset=utf-8">
Helpy of any Kind is highly appreciated
Kind regards
Jürgen Hoffmann
ByteACTION GmbH
cert. Perl Programmer
cert. Linux System Administrator
cert. Java Programmer
Besuchen Sie uns doch auf der CeBIT 2003
in Halle 4/Stand 70
--- End Message ---
