how to insert Mathmetical Symbol into mysql database - Hallo sahabat Tutorials, Pada Artikel yang anda baca kali ini dengan judul how to insert Mathmetical Symbol into mysql database, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.

Judul : how to insert Mathmetical Symbol into mysql database
link : how to insert Mathmetical Symbol into mysql database

how to insert Mathmetical Symbol into mysql database

Selecting    UTF-8 as default server charset.

Also I created a test database and a table as follows:

(1)The database:

CREATE DATABASE `test` /*!40100 CHARACTER SET utf8 COLLATE utf8_general_ci */

(2)The table:

CREATE TABLE `math` (

    `id` INT(10) NOT NULL,

    `symbol` CHAR(1) NULL DEFAULT NULL,

    PRIMARY KEY (`id`)

)

COLLATE='utf8_general_ci'

ENGINE=InnoDB

ROW_FORMAT=DEFAULT

(3)Then write code for    testing given below to  insert  symbol   ∑ :

<?php

$con=mysqli_connect("localhost","root","","abhi");

mysqli_set_charset($con,"utf8");

$sql="insert into cat1(c_name)values('∑')";

mysqli_query($con,$sql);

?>


and  if  you want to go for  inserting   Mathematic  Equation  into your  Mysql Database then follow  given  instruction:

• Convert the math symbols to their corresponding Unicode Entities
• Make sure your MySql database is unicode compliant
• Store the "unicodified"  data in the database
• After retrieving the data from mysql, you may need to convert the unicode characters to their corresponding html entities so that the browser can display them.

Demikianlah Artikel how to insert Mathmetical Symbol into mysql database

Sekianlah artikel how to insert Mathmetical Symbol into mysql database kali ini, mudah-mudahan bisa memberi manfaat untuk anda semua. baiklah, sampai jumpa di postingan artikel lainnya.

Anda sekarang membaca artikel how to insert Mathmetical Symbol into mysql database dengan alamat link https://othereffect.blogspot.com/2017/02/how-to-insert-mathmetical-symbol-into.html

Tweet