|
|
Posted by eisenstein on 08/14/07 17:32
On 14 Aug., 12:16, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> eisenstein wrote:
> > On 19 Jul., 06:30, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> >> eisenstein wrote:
> >>> On 17 Jul., 15:24, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> >>>> eisenstein wrote:
> >>>>> On 17 Jul., 09:42, Toby A Inkster <usenet200...@tobyinkster.co.uk>
> >>>>> wrote:
> >>>>>> eisenstein wrote:
> >>>>>>> i read out an utf-8 xml file with greek or russian/cyrillic
> >>>>>>> characters. i can display it in the browser but if i insert data into
> >>>>>>> anmssqldatabase -field is nvarchar(4000)- i only see ??? or
> >>>>>>> incorrect characters.
> >>>>>> This doesn't seem to be a PHP question. Try one of the microsoft.* groups.
> >>>>>> --
> >>>>>> Toby A Inkster BSc (Hons) ARCS
> >>>>>> [Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
> >>>>>> [OS: Linux 2.6.12-12mdksmp, up 26 days, 11:22.]
> >>>>>> demiblog 0.2.0 Released
> >>>>>> http://tobyinkster.co.uk/blog/2007/06/28/demiblog-0.2.0/
> >>>>> this is a php question: i use php with ms sql server and use php
> >>>>> functions to connect to the ms sql server
> >>>> That doesn't mean it's a php question.
> >>>> You use HTML also - it could be an HTML question. You usemssql- it
> >>>> could be anmssqlquestion. You use Apache or IIS - it could be an
> >>>> Apache or IIS question....
> >>>> I'll bet you even use a keyboard and mouse. Hey, it could be a keyboard
> >>>> or mouse question!
> >>>> The point is - just because you use PHP doesn't mean it's a PHP
> >>>> question. And in this case it isn't. There are a lot of other
> >>>> possibilities. You need to further determine exactly where the problem
> >>>> is.
> >>>> --
> >>>> ==================
> >>>> Remove the "x" from my email address
> >>>> Jerry Stuckle
> >>>> JDS Computer Training Corp.
> >>>> jstuck...@attglobal.net
> >>>> ==================
> >>> - Configuration IIS, PHP 5 and MS SQL SERVER 2000
> >>> - There's the possibility of uploading XML-Documents (UTF-8)
> >>> - A PHP-application reads some values, some of it hascyrillic
> >>> characters
> >>> - Showing the Characters in the Browser is no problem, but some of the
> >>> data should be insertet into an MS SQL Database (The datatype of the
> >>> fields are nvarchar):
> >>> This process does not work, whatever I use I just get wrong
> >>> characters. If I manually copy chars from the XML-File and paste it
> >>> into the database it displays it in the table.
> >>> If I test the same thing with MySQL (and SET NAME UTF-8) everything
> >>> works fine.
> >>> To connect to the MS-SQL Server I used MS-SQL Functions, tried ZEND DB
> >>> Adapter and also Pear AdoDB Connection. I always get the same results.
> >>> I tried to convert the strings from UTF-8 to UCS-2, but then all
> >>> Inserts are terminated.
> >>> $xmldata = ' ';
> >>> //$data = mb_convert_encoding($xmldata, "UCS-2", "UTF-8");
> >>> // Example using ADODB Connection
> >>> require_once 'adodb/adodb.inc.php';
> >>> $db =& ADONewConnection('odbc_mssql');
> >>> $dsn = "DRIVER={SQL Server};Server=localhost;Database=test";
> >>> $db->Connect($dsn, $username, $pwd);
> >>> $db->Execute("INSERT INTO test (test2) VALUES ('$data')");
> >> Sounds like you need to be looking for help in an MS SQL database newsgroup.
>
> >> --
> >> ==================
> >> Remove the "x" from my email address
> >> Jerry Stuckle
> >> JDS Computer Training Corp.
> >> jstuck...@attglobal.net
> >> ==================
>
> > I solved the problem now: I just rewrote the whole app in C#. PHP is
> > not able to communicate with MSSQL and Unicode data.
> > Thnanks for your help
>
> Actually, PHP does fine with Unicode.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================
that's true. PHP is great with Unicode. But not with Unicode AND
MSSQL. Too bad
;)
Navigation:
[Reply to this message]
|