1,105,594 Community Members

excel to mysql with special characters

Member Avatar
vikaspa
Newbie Poster
12 posts since Jun 2005
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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

Member Avatar
diafol
Where are my eyes?
12,983 posts since Oct 2006
Reputation Points: 1,821 [?]
Q&As Helped to Solve: 1,848 [?]
Skill Endorsements: 92 [?]
Moderator
Featured
Sponsor
 
0
 

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

Member Avatar
vikaspa
Newbie Poster
12 posts since Jun 2005
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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 ....

Member Avatar
diafol
Where are my eyes?
12,983 posts since Oct 2006
Reputation Points: 1,821 [?]
Q&As Helped to Solve: 1,848 [?]
Skill Endorsements: 92 [?]
Moderator
Featured
Sponsor
 
0
 
Member Avatar
vikaspa
Newbie Poster
12 posts since Jun 2005
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Dear All

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

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article