cant insert cyrillic or greek charachters into mssql db

[eisenstein]

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.

has anyone expierence with unicode characters and mssql databses?

[Toby A Inkster]

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/0...emiblog-0.2.0/

[eisenstein]

On 17 Jul., 09:42, Toby A Inkster <[e-mail]>
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/0...emiblog-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

[Jerry Stuckle]

eisenstein wrote:

On 17 Jul., 09:42, Toby A Inkster <[e-mail]>
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/0...emiblog-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.
js*******@attglobal.net
==================

[Darko]

On Jul 17, 3:24 pm, Jerry Stuckle <[e-mail]:

eisenstein wrote:

On 17 Jul., 09:42, Toby A Inkster <[e-mail]>
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/0...emiblog-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.
[e-mail]
==================

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.

[Jerry Stuckle]

Darko wrote:

On Jul 17, 3:24 pm, Jerry Stuckle <[e-mail]:

>eisenstein wrote:

>>On 17 Jul., 09:42, Toby A Inkster <[e-mail]>
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/0...emiblog-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.
[e-mail]
==================

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.
js*******@attglobal.net
==================