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 |
|
rkwagle
Starting Member
5 Posts |
 Posted - 2007-01-11 : 02:09:14
|
| how to configure sql server 2005 to support foreign language?i mean, i need to support asian language in my sqlserver. what are the things to consider while designing the table and the databases as well as entering the data to the table.It would be fine if someone could reply me with all the detail configuration and things to consider if i am to let my sqlserver support chinese language. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-01-11 : 06:49:08
|
| 1. you need to use unicode data fields (nchar, nvarchar and ntext type) for your "non-numeric" data.2. you need to identify your 'collation' (@ either database and/or table/column level) for sorting....and this also has some influence on which characters are allowed/displayable within each column.There is also some "regional settings" you may need to implement either on your server or on your clients.Health warning - Info above is supplied on basis of having read previous posts on this topic, and not direct experience of implementing same. |
 |
|
|
rkwagle
Starting Member
5 Posts |
Posted - 2007-01-12 : 00:00:00
|
| thanks for the reply.got to check if it works. |
|
|
|
rkwagle
Starting Member
5 Posts |
Posted - 2007-01-12 : 01:34:58
|
| i tried and what i got is ?????? in the fields. i guess i should make some other configurations too. i am not sure how to know which collation works for the hindi language and how to configure it.any help? |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-01-12 : 07:49:00
|
| are you getting ???? directly in the table...ie when querying via QA/EM or when viewed via some client tool? your 1st priority is to ensure your data is stored correctly and then to configure your client-tools to pickup/display it properly.There are some experienced developers/dba's from india here....might be worthwhile bringing this post to their attention. |
|
|
|
|
|
|
Support for Asian languages.