aakash aakash - 5 months ago 21
SQL Question

allow special characters in codeigniter (specially designing font of a-z and A-Z)

I want to insert data using codeigniter query (sql) when designing font insert into my database it looks like ???? in database.

Answer Source

Change the change the datatype of column

You need to define your columns as nvarchar/nchar if you want unicode data. 
Note, internally SQL Server stores this as UCS-2

if mysql then use utf8 for table

ALTER TABLE yourtable_name CONVERT TO CHARACTER SET utf8

or on your table column

ALTER TABLE <yourtable_name > MODIFY <column_name> VARCHAR(255) CHARACTER 
SET utf8 COLLATE utf8_unicode_ci;