@ollehar : i don't have my destop currently, then for testing in PG : more complex

I think i use

 if(Yii::app()->db->driverName == 'pgsql') { 
     $castedColumnString = "CAST($sColumn as text)"; 
 } 

But alternat is checking DB coluln type.

What is your opinion on the best choice ?

I still think the best option is to compare with 0 or use IS NOT NULL. Or if not possible, switch on question type, I guess.

Btw, fixing this bug is part of putting postgres into Travis. Just have to make sure the test suite works first. :)

: i don't have my destop currently, then for testing in PG : more complex

No docker? Booo.

Docker on my desktop ... not on my 8 years old laptop ...

I still think the best option is to compare with 0

non, no and again no ....
See https://github.com/LimeSurvey/LimeSurvey/commit/ee4f06983913e5b4af2f6d8d6d9d6d7e4d2efbaf#diff-e1a49c510280877fd0e9cbde94631758R47
«Count previous response done not empty»

Compare with Expression Manager count :

1. count(Q1) == 0 if Q1 is a short text and are empty
2. count(Q1) == 2 if Q1 is a number and are 0

OK, then switch on question type, I guess, since different question types encode "not answered" or "empty answer" differently.

But numerical question cannot store "empty answer", right?

numerical and date : set to null if not answered : this is an issue in some situation.

But "not answered" != "empty answer", because "not answered" can be "not seen"?
Bah. Whatever.

Not seen : IS NULL
Not answered (for text and choice) : = ''

You use LimeSurvey sometimes ?

No, I never use LimeSurvey. Obviously, when would I have time? :)

Not answered (for text and choice) : = ''

I was wondering about "not answered" for numerical questions. Also null?

https://gitlab.com/SondagesPro/ExportAndStats/exportCompleteAnswers/-/blob/master/exportCompleteAnswers.php#L93

This settings use code before and after under condition, default adding the string if user see the question (except for numerical and date question)

And here ; https://www.limesurvey.org/forum/team-only/118894-harmonizing-missing-values-in-dataset-null-vs-empty-vs-distinct-values?start=15#187151

Triple-s export already have a solution for non numeric and non date columns :
No clean solution to know a question his hidden or not for numeric and date (only heavy hack solution)

Got it. Then, just another query for numeric and date questions.

Arg ....
https://www.yiiframework.com/doc/api/1.1/CDbColumnSchema#type-detail

return string for decimal and datetime ...

I check for dbType but hope it's not RAW type ...

No free lunch...

With mysql : return DB name ... int(11) for _filecount for example ...

https://github.com/LimeSurvey/LimeSurvey/pull/1388

Thanks, will test later.

I don't know if i set to testing ? I set to another dev ? etc ...

Setting to testing is good, and also write a comment to bump it.

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=29559

Fixed in Release 4.1.5+200217