We're a community of 1076K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,075,939 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

excel to mysql with special characters

Dear All

gone through amny articles on uloading excel to mysql

excellent code in

http://phpexcel.codeplex.com/

http://sourceforge.net/projects/phpexcelreader/

MY issue is i cannot upload following (this is cut and pasted from an excel file)
where in t1 is actually t and subscript 1 opposite to (n² i.e. n and superscript 2)

I am unable to copy ∴ , tn (sign ∴ and t subscript n)

 QUES   Find the first 3 terms of a sequence whose nth term is n²/(n + 1)       Q
Given:  For a sequence, tn = n²/(n+1)       AS1
To Find:    t1, t2, t3      AS2
Solution:   tn = n²/(n+1)   given   AS3
    ∴ t1 = (1)²/ (1 + 1)    substituting n = 1  AS4
    ∴ t1 = 1/ 2     AS5
    ∴ t2 = (2)²/ (2 + 1)    substituting n = 2  AS6
    ∴ t1 = 4/ 3     AS7
    ∴ t3 = (3)²/ (3 + 1)    substituting n = 3  AS8
    ∴ t3 = 9/ 4     AS9
Ans:    t1 = 1/2,  t2 = 4/3,  t3 = 9/4  CA  CA

With this text with mathematical symbols cannot be uploaded

Please help

Thanks in advance

2
Contributors
4
Replies
23 Hours
Discussion Span
3 Months Ago
Last Updated
6
Views
vikaspa
Newbie Poster
12 posts since Jun 2005
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0

∴ is the html encoding for ∴ - I don't know if that helps?

diafol
Keep Smiling
Moderator
10,644 posts since Oct 2006
Reputation Points: 1,628
Solved Threads: 1,508
Skill Endorsements: 57

Dear diafol

Thanks.

I have list of such encodes for different characters.

I want to know whether i need to convert using encoding for special characters.

is there a way to convert directly ....

vikaspa
Newbie Poster
12 posts since Jun 2005
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0
diafol
Keep Smiling
Moderator
10,644 posts since Oct 2006
Reputation Points: 1,628
Solved Threads: 1,508
Skill Endorsements: 57

Dear All

Thanks
I donot know how many such characters will be there
also ther ei smass of data

vikaspa
Newbie Poster
12 posts since Jun 2005
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page rendered in 0.0646 seconds using 2.66MB