Editor retrieves null when column contains data

ViktorAlm

Hey, i've created a jQuery mobile ui for adding data to a table that i also use editor for to load and edit data, the column "utskott" returns null when the data is created by the external form. When i create a new row in phpmyadmin the editor loads it correctly. Editor alse received null on this column when i imported data into the table.

Debug data: http://debug.datatables.net/ebimud
database:
[quote]"1","1358101259","dsfsd","fsdf","sdffds","Festmästeriet, DJ-utskottet, Sexmästeriet, Göteborgskalaset",
"2",,"Viktor Alm","0761695223","jisdfjisdf","wergtgr","rtgrgtr"
"3",,"wotlol","egmkodfgo","kgogkp","erkopgkertgop","efkoerptkerop"
"4","1358106192","34656","yyyt","etyr","Barmästeriet, Skybar, Fotoutskottet, Göta kanal",
"5","wertf","tfwet","ftrf","ttf","rtfwetf","rftr"
"6","wrtffrt","ft","tweft","rtfwwetfr","tftrf","rtffrttfwe"
"7","1358108077","ert","erterrtertret","ertertertert","Göteborgskalaset, Fotoutskottet, Bedas, Natio Gothoburgensis",
"8","1358108152","4r5e23","e423e5","2354235","Göteborgskalaset, Köksmästeriet, Etage blå",
[/quote]

I'd be grateful if anyone had the time to help me.

allan

Are you able to link us to a test case shown think occurring? Or possibly the data that is submitted when you create the new row via Editor? I'm just wondering if the SQL table needs either a default of an empty string ( `''` ) or if Editor need to be given a `default`option of an empty string to have it submit that.

Thanks,
Allan

ViktorAlm

My english is not the best, im trying to load data with editor. I currently have no function for creating rows with editor in my setup. Data created by editor before i removed the function is fine, but when it tries to load data from the database into the column utskott that hasnt been created in editor or phpmyadmin it returns null

ViktorAlm

I found a pattern and it was that post containing åöö and so on created in the external forms. So it had to do with some pages charset being set to ISO, and forcing everything to being utf-8 fixed the problem. So not related to editor at all. Sorry.

allan

No worries - good to hear you got it fixed!

Allan