| Author |
Topic |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2008-04-21 : 09:45:19
|
| Gurus,I am using SQL Server 2000. I can insert characters in my table by using query analyzer. See sample below:Create Table testtable (mydata Nvarchar(200))INSERT INTO testtable(mydata) VALUES ('?????')Problem occurs when I retrieve via query analyzer by using select statement I got "?????" question marks.could anyone please help me to get the correct dataThanks-- krishna |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-04-21 : 09:47:32
|
| I am using the SQL_Latin1_General_CP1_CI_AS collation |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-21 : 10:08:04
|
If you input five question marks you should get five question marks when selecting.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-04-21 : 10:10:02
|
| no peso, I put Cyrillic characters only. Its automatically converting into questin mark.Here is the example : "?????"Is it any possble way to show Cyrillic characters..?-- Krishna |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-21 : 10:23:19
|
Do you have cyrillic installed on the server?Do you have cyrillic installed on the machine where you run QA/SSMS?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-04-21 : 10:26:04
|
| Sorry Peso!!!!How can I check whether cyrillic is installed On my machine.First time i am hearing on this.Thanks-- Krishna |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-21 : 11:00:43
|
Goto "Control Panel" and "Regional and language options".Click "Advanced" tab and scroll down to find Cyrillic page conversion tables.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-04-21 : 11:12:00
|
| Peso Thanks for reply !! There is no Cyrillic page conversion tables in the regional settings.is there any specific website for Cyrillic page conversion ..?Thanks-- Krishna |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-21 : 11:15:24
|
Did you put a checkmark on"1251 (ANSI - Cyrillic)""20880 (IBM EBCDIC - Cyrillic (Russian))""28595 (ISO 8859-5 Cyrillic)""855 (OEM - Cyrillic)""866 (OEM - Russian)"and then click OK?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-04-21 : 11:28:22
|
| Peso, Everything is checked.Thanks-- Krishna |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-04-24 : 16:23:33
|
| I got the solutioncreate table #temp (col nvarchar(20))insert into #temp select N'?????'Select convert(nvarchar,col) from #tempThanks-- krishna |
|
|
|
|
Inserting/Retrieving Characters