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 |
|
avgoustinosc
Starting Member
17 Posts |
 Posted - 2006-11-02 : 01:32:31
|
| Why i cannot insert into my database any Greek letters? Are there any settings for the SQL Server that will allow me to insert Greek into the Database???Any help will be appreciated. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-02 : 01:34:23
|
| Yes. You have to change the COLLATION to a value that matches the Greek alphabet.Peter LarssonHelsingborg, Sweden |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-11-02 : 02:22:23
|
| You could also make each column nvarchar/nchar/ntext which are unicode datatypes, but I don't think you need this for greek letters.--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
avgoustinosc
Starting Member
17 Posts |
Posted - 2006-11-02 : 03:21:26
|
| OK. but how im going to set the collation???? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-02 : 03:24:54
|
| Easy. Open Enterprise Manager.Select the table for which the column is where you want to change collation.Right click the table and choose Design.Select the column. Now alter the value to COLLATION in the window.Peter LarssonHelsingborg, Sweden |
|
|
|
avgoustinosc
Starting Member
17 Posts |
Posted - 2006-11-03 : 05:11:11
|
| What value i have to choose on collation? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-03 : 06:04:21
|
Anyone fromSELECT * FROM ::fn_helpcollations() but it seems to me that Greek_CI_AS is the one you need.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
SQL Server 2000 - What languages are supported???