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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2009-06-11 : 12:20:39
|
| i am making a temp table with a collation of the db that i work on.when i try to insert a row using a dynamic query to this table,i see "good ??????" instead of hebrew letters (where the ????)any idea?thankspelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-11 : 12:33:50
|
| whats the data type used? |
 |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2009-06-11 : 14:18:32
|
| the column with the probem is defined as NVARCHAR(50)Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-06-12 : 15:15:49
|
| What's the collation for the database?Terry-- Procrastinate now! |
|
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2009-06-13 : 08:51:34
|
| i do thisSELECT CAST(NULL as NVARCHAR(50)) as Company , CAST(NULL as NVARCHAR(50)) as ServiceNameINTO #ReportTablewhen i check the COLLATION of the column i see it's :SQL_LATIN1_GENERAL_CP1_CI_AS Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
|
|
|
Dynamic sql and hebrew