| Author |
Topic |
|
eaflags
Starting Member
6 Posts |
 Posted - 2010-11-26 : 08:52:09
|
| Greetings,And Help! having a problem with my data, most of the cells in the TEXT columns are un-formatted, identifiable by excel or open and I can not change the format.General format as ************************on one of the text columns when downloading, the header has, <p>Description</p> ( new I think)nothing seams to be different in the PHP code, I thing, The collation should be lantin1_swedish_ci , on all, right?This is what I get in the fields "<p>jack and Jill went up the hill</p>"even after I delete the " and save the spreadsheet. you don't see them but there there.When importing I get"jack and Jill went up the hill"Any help at all would be gratefully appreciated ....CynthiaV/r |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-26 : 09:05:47
|
| Looks like somethings trying to use xml - could be that it's delimiting the column to cater for a separator being present.Or could be an html paragraph tag. Maybe it's trying to cater for multiple paragraphs in the field.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
eaflags
Starting Member
6 Posts |
Posted - 2010-11-26 : 10:28:48
|
| A Cursors what's that, how would that work, not now, how about a gun to the head..would any updates, make these changes to my Cpanel. I been doing the same thing for years import / export with no problems.It has to be that I am downloading this "thing",should I check to see if a box to delimit when downloading has been checked and un-check it.. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-26 : 10:33:43
|
| Where are you downloading from and how are you doing it?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
eaflags
Starting Member
6 Posts |
Posted - 2010-11-26 : 10:42:38
|
| download files from a database in phpmyadmin,I beleive it SQL 5.0 |
|
|
|
eaflags
Starting Member
6 Posts |
Posted - 2010-11-26 : 10:45:56
|
| o. I export to, Microsoft Excel 2000, NULL, _TABLE_ |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-26 : 10:52:45
|
| This wouldn't be mysql 5.0 would it? The sql here stands for sql server.I suspect this is a php issue.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
eaflags
Starting Member
6 Posts |
Posted - 2010-11-26 : 11:02:49
|
| yes, Iit has a little box and in it a little cent sign an n the under that a 1/2, I believe it should be a small image not code in a box. * Server: Localhost via UNIX socket * Server version: 5.0.89-community * Protocol version: 10 * User: flagsupp@localhost bad box here * MySQL charset: UTF-8 Unicode (utf8)Web server * cpaneld * MySQL client version: 4.1.22 * PHP extension: mysqlphpMyAdmin * Version information: 3.2.4 * Documentation * Wiki * Official Homepage * [ChangeLog] [Subversion] [Lists] |
|
|
|
eaflags
Starting Member
6 Posts |
Posted - 2010-11-26 : 11:08:25
|
| on this page it has the collation as utf8_general-cion my doc. all the collation are set to, lantin1_swedish_ci |
|
|
|
|
Text fields, Adding " around text