php-windows Digest 20 Mar 2007 22:24:55 -0000 Issue 3170
Topics (messages 27590 through 27592):
Re: Upgrading?
27590 by: bedul
27591 by: Gustav Wiberg
Re: Japanese text in MSSQL database
27592 by: Mike Matz
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:
php-windows@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
----- Original Message -----
From: "Gustav Wiberg" <[EMAIL PROTECTED]>
To: "'bedul'" <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2007 1:35 PM
Subject: RE: [PHP-WIN] Upgrading?
Hi!
Yes, it's windows...
Ok, but is current customers affected by the upgrade? (If they don't have
any special functions on their websites).
What is not so long time? Do I have to restart the server? (Windows 2003) ?
IS the IIS restarted?
[bedul]
i mean to upgrade is take a time but not too long. cmiiw
iss is a server, where u should restart the iis after the upgrade. i don't
realy try it out.. but i learn something.. which is server should be
restart.. if the server (win2003) has be restart.. i hope you only restart
IIS only not the server.
=======================================================
The final question: Can I do this on working-hours without getting angry
customers?
[bedul]
noo.. you should try other time.
i suggest you don't try at working hours. the main problem is FAIL. if you
do some serious problem.. you will manage to recover.. but in the working
hour.. you will get more depressed..
man.. i hate to say this.. you not allowed to stress!!
final question:
is there a problem that make you upgrade the php?? or is just renew the
php??
how about use apache server??
sry 2 final question
======================================================
Best regards
/Gustav Wiberg
-----Original Message-----
From: bedul [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 20, 2007 2:50 AM
To: Gustav Wiberg
Subject: Re: [PHP-WIN] Upgrading?
fyi u using windows right?
is not soo long actualy.. just sit and make some coffe to relax.
----- Original Message -----
From: "Gustav Wiberg" <[EMAIL PROTECTED]>
To: <php-windows@lists.php.net>
Sent: Monday, March 19, 2007 3:08 PM
Subject: [PHP-WIN] Upgrading?
Hi there!
Upgrading from PHP 5.01 -> 5.10. How long time does this take? Anyone who
knows?
Does this effect customers or must such an installation been done when
customers is not online?
Suggestions?
Please help :-)
Best regards
/Gustav Wiberg
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hi again!
Thanks for your input! It's a component called JpGraph that demands >5.10 (I
have tested with current configuration (5.01) and it doesn't work)
JpGraph - http://www.aditus.nu/jpgraph/
I'm not going to update to Apache on an already working IIS. It's a waste of
time as long as the IIS works fine.
Best regards
/Gustav Wiberg
-----Original Message-----
From: bedul [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 20, 2007 8:06 AM
To: Gustav Wiberg
Cc: php-windows@lists.php.net
Subject: Re: [PHP-WIN] Upgrading?
----- Original Message -----
From: "Gustav Wiberg" <[EMAIL PROTECTED]>
To: "'bedul'" <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2007 1:35 PM
Subject: RE: [PHP-WIN] Upgrading?
Hi!
Yes, it's windows...
Ok, but is current customers affected by the upgrade? (If they don't have
any special functions on their websites).
What is not so long time? Do I have to restart the server? (Windows 2003) ?
IS the IIS restarted?
[bedul]
i mean to upgrade is take a time but not too long. cmiiw
iss is a server, where u should restart the iis after the upgrade. i don't
realy try it out.. but i learn something.. which is server should be
restart.. if the server (win2003) has be restart.. i hope you only restart
IIS only not the server.
=======================================================
The final question: Can I do this on working-hours without getting angry
customers?
[bedul]
noo.. you should try other time.
i suggest you don't try at working hours. the main problem is FAIL. if you
do some serious problem.. you will manage to recover.. but in the working
hour.. you will get more depressed..
man.. i hate to say this.. you not allowed to stress!!
final question:
is there a problem that make you upgrade the php?? or is just renew the
php??
how about use apache server??
sry 2 final question
======================================================
Best regards
/Gustav Wiberg
-----Original Message-----
From: bedul [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 20, 2007 2:50 AM
To: Gustav Wiberg
Subject: Re: [PHP-WIN] Upgrading?
fyi u using windows right?
is not soo long actualy.. just sit and make some coffe to relax.
----- Original Message -----
From: "Gustav Wiberg" <[EMAIL PROTECTED]>
To: <php-windows@lists.php.net>
Sent: Monday, March 19, 2007 3:08 PM
Subject: [PHP-WIN] Upgrading?
Hi there!
Upgrading from PHP 5.01 -> 5.10. How long time does this take? Anyone who
knows?
Does this effect customers or must such an installation been done when
customers is not online?
Suggestions?
Please help :-)
Best regards
/Gustav Wiberg
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
I wanted to follow up on this because I didn't get any responses. I did
eventually get proper Japanese text from the MSSQL database using a COM
object and the MS ADODB tools:
$obj=new COM('ADODB.connection',NULL,CP_UTF8);
$obj->open("Provider=sqloledb;Data Source=$server,1433;Network
Library=DBMSSOCN;Initial Catalog=$database;User
ID=$username;Password=$password;")
I set this up in a custom ADODB class and simply used it to re-populate
international fields in the data I was already getting from PDO. It's a
pretty sloppy solution but it was easier to continue using the PDO
interface for the majority of my code.
Hope this helps someone in the future :)
-----Original Message-----
From: Mike Matz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 14, 2007 11:54 AM
To: php-windows@lists.php.net
Subject: [PHP-WIN] Japanese text in MSSQL database
Hello,
I'm working with an MSSQL 2000 database that contains Japanese
characters in ntext columns. I'm not entirely sure how to see what
encoding or charset it's using, but there is a ColdFusion admin
application that can display the data in UTF8 as well as accept the
data. I'm trying to access this data from PHP for import into a MySQL
database, and I'm currently using the PDO ODBC driver. I had difficulty
getting other drivers working when I began importing data, either due to
the charset/encoding on these fields or due to the long text in some of
the fields, and the PDO ODBC driver in PHP 5.2.0+ was the one that
seemed to work the best. However, I'm just now realizing that the
Japanese characters are being replaced with "?" characters when I do the
select. I found I had this problem on the MySQL end before, but I
solved it by adding some SQL calls when initializing the connection:
"SET CHARACTER SET utf8",
"SET collation_connection = 'utf8_general_ci'",
"SET character_set_database = utf8",
"SET character_set_server = utf8",
"SET character_set_client = utf8",
"SET character_set_filesystem = utf8",
Is there something similar I need to do with MSSQL? Is there an option
in the PDO ODBC driver I need to set somehow? I'm guessing there's
probably a simple solution but thus far I've been unable to find
anything. Any help or insight would be greatly appreciated!
Thanks,
Mike
--- End Message ---
