Welcome to my blog, hope you enjoy reading
RSS

Wednesday 18 July 2012

How to insert multiple languages in database


How to insert multiple languages in database


1. create database with the default character set as utf8
example:

CREATE DATABASE `database name ` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
2.create table.
example:
create table `telugunames` (name varchar(100))
3. insert data.
example:
INSERT INTO `japanese`.`telugunames` (`name`) VALUES ('అప్పజి');

0 comments: