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.
| Author |
Topic |
|
L1nux_ee
Starting Member
2 Posts |
 Posted - 2005-08-17 : 04:26:56
|
| Hallo, this is my first post, i need to add arabic fonts to mssql 2000 server, there is an existing fonts for arabic such as tahoma(arabic), the problem is that when i insert data with arabic fonts, when i retrieve it it appears as question marks, ?????,is there a way to solve this,thanks in advance, |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-08-17 : 08:02:10
|
| Check the columns in your table where you need to store Arabic text, make sure they are nvarchar instead of varchar. Nvarchar will allow you to store Unicode values that will preserve the Arabic characters. The fonts that are installed on the server will not affect this capability. |
 |
|
|
L1nux_ee
Starting Member
2 Posts |
Posted - 2005-08-17 : 08:30:16
|
| Well, Thank you for replying, i build a new table with nvarchar fields, but the same problem exists, the data appears as ??????the problem is that when i write arabic in the query using query analyzer the query is correct shown, but when i retrieve the data it appears as ????, and when i go to the options in the query analyzer and choose tahoma(arabic) font in the sample windows it shows AaBbCcXxYyZz, i think that the part XxYyZz should be arabic fonts instead, does this sound?thanks in advance |
|
|
|
|
|
|
|
|
Adding Fonts To MSSQL 2000 Server