Posted by Jerry Stuckle on 07/18/07 14:52

Darko wrote:
> On Jul 17, 3:24 pm, 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
>>>>> an mssql database -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 use mssql - it
>> could be an mssql question. 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
>> ==================
>
> I agree. Especially that most probably the problem lies in your
> default db character set (encoding) setting. Most probably MS uses
> latin or something like that, so you'll have to configure it being
> unicode (utf8 or whatever you use in your file). However, if you used
> postgres for example, you could be armed with pg_set_client_encoding
> and pg_client_encoding functions which would probably be able to help
> you solve the problem. Mssql, ... well, seems to me PHP is not
> equipped to do the same with that. That's why I never use it - except
> when working .net or similar.
>

Actually, MySQL handles it just fine. But you have to set the
appropriate charset. Also, you have to have the correct charset in your
HTML, for instance.

Lots of possibilities - none of them PHP.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]