Thu 22 Dec 2016

I am ashamed!

Categories : Thoughts / Lessons
Comments here
Fri 2 Dec 2016

 

Just in case if Arabic characters appearing as ????? in your column and if you are using MySql DB along with .NET Provider, 

Check below properties of schema, table and column and connectionstring that use to connect to DB

  1. DEFAULT_CHARACTER_SET_NAME = utf8
  2. DEFAULT_COLLATION_NAME = utf8_general_ci
  3. TABLE_COLLATION = utf8_general_ci
  4. COLLATION_NAME = utf8_general_ci
  5. CHARACTER_SET_NAME = utf8
  6. .NET Connection string set to have = 'charset=utf8'

 

Connection string example

'datasource=<server>;port=3306;username=<userid>;password=<password>;sslmode=none;database=<dbname>;charset=utf8'

 

Queries that may help to find above information are 

SELECT * FROM information_schema.SCHEMATA S

WHERE schema_name = "<database-name>";

 

SELECT * FROM information_schema.`TABLES` T,

information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA

WHERE CCSA.collation_name = T.table_collation

AND T.table_schema = "<database-name>"

AND T.table_name = "<table-name>";

  

SELECT * FROM information_schema.`COLUMNS` C

WHERE table_schema = "<database-name>"

AND table_name = "<table-name>"

AND column_name = "<column-name>";

 

Comments here
Thu 29 Sep 2016

Short Documentary about Eagle's Guardian of the Sky - A Symbol of Pride

Comments here
Sun 11 Sep 2016

This share is not because as a Muslim.

Also you may choose to deny God, but how you can deny and be in denial of these few facts regarding Muhammad.

Listen it for around 2 minutes, think and decide or ignore as per your choice

Comments here
Thu 11 Aug 2016

To write arabic unicode script in MsOffice using shortcut, type fdfa then press alt+x, it will convert into its respective unicode

To write in HTML, type &#xfdfa;  it will render it as respective unicode.

It may be require to increase the font to make it more readable

Below are some examples

fdfa Alt+x صلى الله عليه وسلم

Fdf2 Alt+x الله

Fdf3 Alt+x اكبر

Fdf4 Alt+x محمد

Fdf5 Alt+x صلعم

Fdf6 Alt+x رسول

Fdf7 Alt+x عليه

Fdf8 Alt+x وسلم

Fdf9 Alt+x صلى 

 

Below URL to list all unicodes

www.unicode.org/charts/PDF/Unicode-3.1/U31-FB50.pdf

 

Comments here
Mon 13 Jul 2015

بہت سخت الفاظ ہیں۔ اللہ تعالیٰ ان شہیدوں کے ماں باپ اور گھروالوں کو صبر عطا فرماۓ۔ آمین

 

Eid+not+so+Saeed.png



Tags:
Categories :
Comments here
Fri 27 Mar 2015

Dedicated to Pakistan Air Force Sherdils... aerobatic display team!

Categories : Pics / Images Shot
Comments here