What is the differnce between unicode and latin character set.How can we choose the character set while creating table.Is there any way to convert unicode characters into Latin.
Unicode is your best choice if your column needs to support more than 7-bit ASCII. The choice depends on repertoire, client character set, apps in use. Start you research with either:
1) The orange book: "Getting Started: International Character Sets and the Teradata Database", or
2) The International Character Set Support reference manual.
Also, use the SQL Translate function for conversion.