Problem with Greek Character - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

Problem with Greek Character

Author

Topic

sant25
Starting Member

2 Posts

Posted - 2004-10-11 : 07:52:57

Hi:

This is Santanu. We are running Sql Server 2000 in our Server for our website www.eshivaji.com.

Though we can display Greek character link and text in our website www.eshivaji.com but the problem arise when the same application been used in another greek website http://connect.thelo.gr/busdir/

Example:

http://www.eshivaji.com/viewindetails.asp?pid=10
(working fine)

http://connect.thelo.gr/busdir/viewindetails.asp?pid=6 (garbage character)

Both website using SQL Server 2000 (using varchar as datatype) but what goes wrong with the Greek character in http://connect.thelo.gr/busdir/ website?

We are looking for a help and if anyone knows this issue, please let us know. Thanks in advance.

Regards,
Santanu.

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2004-10-11 : 08:54:43

Neither worked for me.
The first one incorrectly claims that the page's character encoding is ISO-8859-1 when it's actually ISO-8859-7.
The second one has been downconverted (probably to ISO-8859-1!) and had all the Greek characters replaced by question marks.
I would suggest that you look at the collation (which influences the character repertoire) on the varchar column in each case: I would guess it's using the database/server default and that it's set to a collation using CP-1253 (approx ISO-8859-7) in one case and CP-1252 (approx ISO-8859-1) in the other.

You really should fix the character encoding on the page too.

sant25
Starting Member

2 Posts

Posted - 2004-10-12 : 04:18:30

Thank you for your reply. I am abel to slove this problem using ISO-8859-1.

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2004-10-12 : 06:52:10

quote:
Originally posted by sant25

Thank you for your reply. I am abel to slove this problem using ISO-8859-1.

This seems improbable given that there are no Greek characters in ISO-8869-1.

X002548
Not Just a Number

15586 Posts

Posted - 2004-10-12 : 10:04:23

I saw a movie about a Greek Character once....boy could he dance...

I'm just curious though...at what layer are you doing this?

Brett

8-)

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2004-10-12 : 10:18:34

quote:
Originally posted by Arnold Fribble
This seems improbable given that there are no Greek characters in ISO-8869-1.

I take that back! Using character references in the web page will work fine... which is what the second web site is now doing.

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2004-10-12 : 10:37:23

I once had a problem with a greek character ... but that's a story for another place and time.

- Jeff

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources