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 |
|
BadSectorGR
Starting Member
6 Posts |
 Posted - 2008-01-22 : 10:24:30
|
| Dear All Hi,I have installed MS SQL Server 2005 on Windows Server 2003 (regional settings . Server collation is Greek_CI_AS and database collation is Greek_CI_AS. I am using an external application which stores data to this database and I am able to write Greek characters in a field but after i save the record this text is transformed to many ???????. What could be the problem? Thanks in advance |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-22 : 10:28:01
|
Are you using NVARCHAR to store the characters?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-22 : 10:32:58
|
And no, you can't alter the table to use NVARCHAR afterwards and think the already stored data will be converted.You will have to re-import.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
BadSectorGR
Starting Member
6 Posts |
Posted - 2008-01-22 : 10:39:10
|
| Thanks for the quick reply. I am just the consultant of this commercial application but after checking the table i can see that it is not a nvarchar field. No we still dont have any data in it that we need to transform. The only solution is to change the field type to nvarchar and records added from now on will be shown correctly? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-22 : 10:40:29
|
It should be, yes, in SSMS or EM.I have no clue how that will impact rest of application, especially the front-end thingy.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Greek Characters problem