Arabic SQL+ASP

Enable Arabic in MSSQL DB, the correct way, as of Sep 2018
Tested in Alwah and euLabels

> Fields in db should be nchar, nvarchar or ntext
> Do not waste time setting up db, default format should work
> Files should be saved in format UTF-8 BOM, saving them as UTF-8 is not enough
> Once you have "Default.asp" files saved as BOM, included files can be UTF-8, that is fine
> Then you can save with
Insert Into blabla() values(N'الإسم', N'الكنية')
Saving into db using N'value'
> If you do all above, you will be able to see them in DB correctly using SSMS, and see them in Web correctly

Views 1128 Downloads 421

'Arabic', 'SQL', 'encoding', 'decoding', 'encode', 'decode', 'char', 'Ar', 'N', 'bom', 'UTF8', 'UTF-8', 'nchar', 'nvarchar', 'ntext'

Database Classic ASP