|
|
Posted by Jerry Stuckle on 08/14/07 10:16
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.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|