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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Multi Languages in same Field

Author  Topic 

wafi
Starting Member

12 Posts

Posted - 2004-06-16 : 14:28:08
Hi All,

I have a problem with multi Languges in SQL Server the problem is i have a field that can be contain English or Arabic or Turkish langauges , no problem with english but the arabic converts to ????
and the turkish converts to english characters.

Anyone Could help me with that

Best Regards
Wafi Mohtaseb

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-16 : 14:32:54
What data types are you using for these columns?

Tara
Go to Top of Page

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2004-06-16 : 15:07:45
Certainly you'll need to be using a Unicode column (nchar, nvarchar or ntext type).

quote:
the turkish converts to english characters.


AFAIK, most of the characters in the Turkish alphabet are the same as those in the latin alphabet. I presume the ones you're having problems with are those not in ISO 8859-1?
i.e.

U+011E Latin Capital Letter G With Breve
U+011F Latin Small Letter G With Breve
U+0130 Latin Capital Letter I With Dot Above
U+0131 Lattin Small Letter Dotless I
U+015E Latin Capital Letter S With Cedilla
U+015F Latin Small Letter S With Cedilla
Go to Top of Page
   

- Advertisement -