Collation

Hi
I have a table with a column as NVARCHAR(500).
The column has some values like this:
ROW1=> ?kergatan? 4?2
ROW2=> TORRE CUSCATLAN 6° NIVEL = > °
ROW3=> EX. EDIF. ANTEL CENTRO DE GOBIERNO 1° PL
ROW4=> MARJORIE DE QUI?ONEZ
I want to avoid the UNICODE character set as seen above. Can anyone please
advice what Collation should I set for that column?
Thanks in advance,
Arun
Why do you want to avoid the UNICODE? What do you want to convert all of
those characters to?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Arun Shankar" <ArunShankar@.discussions.microsoft.com> wrote in message
news:185DBA54-A6AA-4786-BACA-2E48B97C36A2@.microsoft.com...
> Hi
> I have a table with a column as NVARCHAR(500).
> The column has some values like this:
> ROW1=> kergatan 42
> ROW2=> TORRE CUSCATLAN 6 NIVEL = >
> ROW3=> EX. EDIF. ANTEL CENTRO DE GOBIERNO 1 PL
> ROW4=> MARJORIE DE QUIONEZ
> I want to avoid the UNICODE character set as seen above. Can anyone please
> advice what Collation should I set for that column?
> Thanks in advance,
> Arun
|||Unfortunaly if you want to have different languages within a database table
then unicode is the way to go.
The reason is that a collation is normally specific for a country so if you
change it to one collation then you may find your character change.
Can you please tell us why you no longer want a unicode field ?
In the meanwhile have a look at this
http://msdn.microsoft.com/library/de...ar_da_6ttf.asp
Peter
"Only two things are infinite, the universe and human stupidity, and I'm not
sure about the former."
Albert Einstein
"Arun Shankar" wrote:

> Hi
> I have a table with a column as NVARCHAR(500).
> The column has some values like this:
> ROW1=> ?kergatan? 4?2
> ROW2=> TORRE CUSCATLAN 6° NIVEL = > °
> ROW3=> EX. EDIF. ANTEL CENTRO DE GOBIERNO 1° PL
> ROW4=> MARJORIE DE QUI?ONEZ
> I want to avoid the UNICODE character set as seen above. Can anyone please
> advice what Collation should I set for that column?
> Thanks in advance,
> Arun
|||I will be using XML to create reports from those columns. XML supports UTF8
character set and its not able to create reports with this data. All I want
to do is avoid those special characters in that column and made some readable
set of data. I am assuming changing the Collation for that Column will
resolve the issue. Please correct me if I am wrong. Also let me know if there
is any other way to do this.
Thanks,
Arun
"Adam Machanic" wrote:

> Why do you want to avoid the UNICODE? What do you want to convert all of
> those characters to?
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
> "Arun Shankar" <ArunShankar@.discussions.microsoft.com> wrote in message
> news:185DBA54-A6AA-4786-BACA-2E48B97C36A2@.microsoft.com...
>
>
|||Probably changing the column to VARCHAR, rather than altering the collation.
But I'm not sure what this will do with the 2-byte characters.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Arun Shankar" <ArunShankar@.discussions.microsoft.com> wrote in message
news:435E4B78-DC0B-48BD-9D67-B9E5B8013814@.microsoft.com...
> I will be using XML to create reports from those columns. XML supports
UTF8
> character set and its not able to create reports with this data. All I
want
> to do is avoid those special characters in that column and made some
readable
> set of data. I am assuming changing the Collation for that Column will
> resolve the issue. Please correct me if I am wrong. Also let me know if
there[vbcol=seagreen]
> is any other way to do this.
> Thanks,
> Arun
> "Adam Machanic" wrote:
of[vbcol=seagreen]
please[vbcol=seagreen]