I am trying to insert unicode characters from excel file into phpmyadmin database through coding,but database is not accepting unicode characters and even date type,please help me if anyone having idea abt this,even i tried by converting .xls to csv format but .csv file does not support unicode characters and not even date,English characters are working but not unicode...please help me for this...
Lalita_shah
0
Newbie Poster
Recommended Answers
Jump to PostI am trying to insert unicode characters from excel file into phpmyadmin database through coding,but database is not accepting unicode characters and even date type,please help me if anyone having idea abt this,even i tried by converting .xls to csv format but .csv file does not support unicode characters and …
Jump to PostI m using phpmyadmin and structure of my table is
CREATE TABLE `test1` (
`Date` DATE NOT NULL ,
`Word` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_bin;
please help if possible...Its all right then, mysql's utf8 character …
Jump to Postthere is not at all problem with the structure of the table,actually i m not getting how to insert unicode characters thr coding from .xls file to database.
In this case you can head in two approaches -
- one use of some external plugin (like one I mentioned in …
All 12 Replies
network18
15
Practically a Master Poster
Lalita_shah
0
Newbie Poster
network18
15
Practically a Master Poster
Lalita_shah
0
Newbie Poster
network18
15
Practically a Master Poster
Lalita_shah
0
Newbie Poster
network18
15
Practically a Master Poster
Lalita_shah
0
Newbie Poster
network18
15
Practically a Master Poster
Lalita_shah
0
Newbie Poster
Lalita_shah
0
Newbie Poster
network18
15
Practically a Master Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.