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 |
|
craigwg
Posting Yak Master
154 Posts |
 Posted - 2010-04-12 : 14:45:16
|
| I have a survey I am building using SQL that requires me to have the survey availalble in multiple languaes, including spanish, chinese, arabic and many more. I am working on Spanish now. Spanish has characters that are not translating in SQL. I created the data and used a create statement but when I view the survey I am seeing the little boxes where the special characters are.The characters appear fine in the query I pasted into SSMS. It's just stored in the DB incorrectly. What adjustment do I need to make? I've been doing reading...something about unicode...not collation...help!Craig Greenwood |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-12 : 14:47:03
|
| use unicode datatypes like nvarchar for storing other language chars------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
craigwg
Posting Yak Master
154 Posts |
Posted - 2010-04-12 : 14:54:32
|
| Just a moment ago I tried altering the datatype of the column to ntext (currently it is set to text) and was met with this error:Msg 4927, Level 16, State 1, Line 1Cannot alter column 'surveyls_welcometext' to be data type ntext.what do you do with that?Craig Greenwood |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-12 : 14:57:07
|
| create a new column, copy content from this to new and then drop this column------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
craigwg
Posting Yak Master
154 Posts |
Posted - 2010-04-12 : 15:12:32
|
| Ah, found it! I had to go to Tools>>Options>>Designers>>Table and Database Designers in SSMS and change the setting to Prevent Saving Changes That Require Table Recreation. All is well!Craig Greenwood |
|
|
|
|
|
|
Using multiple languages like Spanish