18.Varchar Vs nVarchar || ascii vs unicode || insert multi languages data ||SQL IN TELUGU

This small video is intended for the audience stuck in their interview when asked for the differences among Varchar ,nVarchar and ascii vs unicode

Here are some basic rules which you may want to keep in mind. While storing Unicode data, the column must be of Unicode data type (nchar, nvarchar, ntext). Another rule is that the value must be prefixed with N while insertion other languages than english in SQL statements

Create Table MultiLanguage_Will_Not_Work (i int, j varchar(10), k varchar(100))
go
-- Hindi
Insert into MultiLanguage_Will_Not_Work values (1, 'with N', N'???? ??? Sekkhar ??')
go

-- Hindi
Insert into MultiLanguage_Will_Not_Work values (1, 'with N', N'???? ??? Sekkhar ??')
go
-- Tamil
Insert into MultiLanguage_Will_Not_Work values (2, 'without N', '??? ????? Sekkhar ??????')
go
Select * from MultiLanguage_Will_Not_Work
go


How to change font size in sql server management studio? SQL in Telugu
   • 15.How to change font size in sql server m...  

Delete vs Drop vs Truncate Sql Server in Telugu
   • 14.Delete vs Drop vs Truncate Sql Server i...  

Merge Statement in SQL Telugu | How to Merge Statements in SQL
   • 13.Merge Statement in SQL Telugu | How to ...  

Data Warehouse in Telugu

   • Data Warehouse in Telugu  



ETL and SSIS :    • SSIS  in Telugu :SQL Server Integration Se...  


Tableau in Telugu: Tableau Colors

   • 4.Tableau in Telugu: Tableau Colors  


EXCEL IN TELUGU: FETCH DATA FROM SQL TO EXCEL

   • EXCEL  IN TELUGU:  IMPORT DATA  FROM SQL T...  


BIGDATA in TELUGU

   • BIGDATA in TELUGU  


Tableau in Telugu: Import data from Excel

   • 2.Tableau  in Telugu: Import data from Exc...  


Pareto Chart Analysis Excel in Telugu

   • Pareto Chart Analysis Excel in Telugu