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 |
|
pontifikas
Starting Member
32 Posts |
 Posted - 2004-09-24 : 05:43:57
|
| I'm using Sql Server 2000 on M$ Server 2000.I connect to a remote database that has records in it, in Greek.I cannot read these records.I get garbagge characters.I cannot also write in greek in my data base.What is curious is that the field names can be in Greek but not their records?It appears to be a problem of the sql program in general, as when I write in Greek, while I input the chars they appear Greek and as soon as I press enter to store the record in the field, the greek chars are automaticaly transformed into English.Any ideas?Thanks in advance :) |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-09-24 : 07:29:20
|
what collation do you have on table/column? are your fields nvarchar?Go with the flow & have fun! Else fight the flow  |
 |
|
|
pontifikas
Starting Member
32 Posts |
Posted - 2004-09-24 : 07:36:27
|
| The master base's collation at the setup was set to Greek.Well there are various data types used in each data base.Same may be nvarchar.I want this machine to be a subscriber(replication) of the remote one I mentioned so I need to ba able to read in greek whatever the other DB has.The other machine reads Greek fine. :(I fight the flow at my home and go with it at my job.... ;) |
|
|
|
|
|
|
Problem With Fonts