Testing pictag

pictag here

Nested links

Testing 2 types of links: Link 1: link 1

Link 2: link 2

Link 3: Download
Full Prescribing
Information,
including Patient
Information with
important
warnings

Push value to the dataLayer when button is clicked

Click on HTML a and span

• For Patients
• For Healthcare Professionals

• For Patients
• For Healthcare Professionals

Trigger GTM on button click

This is my green button.. Continue >>

Testing GA New Social Feature...

Below is the iframe format of the FB like button...

Uploading Chinese Text to MySQL database

In SQL Server, if you want to insert Chinese or other language character to a table, it was pretty simple, just specify the column type as NVARCHAR, and when you insert you can just use "N'chinese text here" but I found out that there's no such thing as NVARCHAR in MySQL database and hence this article.

To insert Chinese character:

• Specify database character-set as UTF-8


• Specify table or column collation set as UTF-8


• In your web.config connection string, specify charset UTF-8
  e.g. <add name="MySqlConnString" connectionstring="server=IPAddress;userid=mysqluser;password=pa$$w0rd;database=mydb;pooling=false;charset=utf8 "/>
  
  This is to tell the application to use UTF-8 charset when talking to the database