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 |
|
calvin_nguyen
Starting Member
4 Posts |
 Posted - 2008-03-03 : 13:29:18
|
| Hi all,I have a nvarchar field that holds a variety of languages including English, French, Arabic, Chinese, Russian and more. These work fine. I populate this data from Excel or Outlook simply by copying and pasting.However when it comes to Punjabi, the paste results in English alphabet characters with the occasional accent character. I have Punjabi fonts GurbaniLipi and GurbaniLipiLight installed on the SQL Server box, and on the same machine the Punjabi text appears properly in Outlook.Do I need to make an adjustment to the column? I'm not sure which collation to use in this case, or whether I'm even on the right track believing collation to be the issue.Thanks for your help,Calvin |
|
|
calvin_nguyen
Starting Member
4 Posts |
Posted - 2008-03-05 : 14:30:17
|
| Hi,No one has any ideas about this?Thanks,Calvin |
 |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2008-03-06 : 04:49:08
|
| See:http://en.wikipedia.org/wiki/Gurmukh%C4%AB"The Unicode range for Gurmukhi is U+0A00 to U+0A7F. Using Unicode for Gurmukhi has only recently started to become widespread. Many sites still use proprietary fonts that convert Latin ASCII codes to Gurmukhi glyphs."Sounds like this is your problem.This might be of some help:http://guca.sourceforge.net/applications/guca/ |
|
|
|
calvin_nguyen
Starting Member
4 Posts |
Posted - 2008-03-07 : 14:44:54
|
| Arnold, you just rock. Thanks.I'm sure your reply will help people that experience this issue in the future. |
|
|
|
|
|
|
Copy & Paste Indic Language Into Field