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 |
|
bniru101
Starting Member
4 Posts |
 Posted - 2008-05-05 : 14:28:24
|
| Hi,Data in the table appearing with strange characters [probably unicode]. For instance obeserve the string [marked in red color] "Rod. Anhang�era s/n§". When I export the same to excel and apply language as portuguese it shows properly. The actual portuguese languguage has ascents in the sentence. This where the problem is seen.I wanted to display them back in normal form could please suggest me the best possible way to cast such characters.Thanks in advance for looking into this issue.Thanks,Niranjan. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-05 : 22:45:45
|
| Tried with collate clause in select statement? |
 |
|
|
bniru101
Starting Member
4 Posts |
Posted - 2008-05-07 : 12:38:14
|
| Can you please give me hint how to try with collate |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-07 : 12:47:34
|
quote:
Originally posted by bniru101
Can you please give me hint how to try with collate
read about COLLATE in books online |
|
|
|
bniru101
Starting Member
4 Posts |
Posted - 2008-05-07 : 16:39:30
|
| Thanks for your quick response.We have 2 column address1 & address2 with collate SQL_Latin1_General_CP1_CI_AS.The data is being loaded into this table from .csv files using DTS job. When I retrieve the data from address1 & address2 column, the text appears '�' boxes for all characters which have accent,as shown in the below. ================================================================address1 | Address2================================================================der Stadt Z�r Fraum�nsterstrasse Gallus FerdR�esch AG Harzb�chelstrasse ----------------------------------------------------------------- As per your suggestion I have created temp table with 2 columns with collation Latin1_General_CP1_CI & Latin1_General_CP1_CI_KS but the data still appears the same.Please correct me if my approach is in correct.Thanks,Niru. |
|
|
|
bniru101
Starting Member
4 Posts |
Posted - 2008-05-07 : 16:46:58
|
| My task is to make this square boxes appear as accent characters in the db.Can you please suggest some solution.Thanks,Niru. |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2008-05-08 : 04:17:19
|
| I'm guessing from the examples that the character that's getting messed up in each of these cases isü 'LATIN SMALL LETTER U WITH DIAERESIS' (U+00FC)Since the character you've said is appearing as a box is U+0081, I'm guessing that the csv file is encoded in either Code page 850 or 437 rather than CP-1252. You need to tell the part of the DTS job that's reading the file to expect the right code page. |
|
|
|
|
|
|
Unicode characters