I need to establish a data set in CB (for later export/import with xml) regarding external documentation, for example I need a decimal field (with . instead of the German ,) for adding for example the number of rooms of a flat, so that should be 1 or 1.5 or 2 or 2.5 and so on in the mysql field.

I would like to have a drop down function in the edit for the user and added the value/name pairs like 1/1 Zimmer and 1.5/1,5 Zimmer and so on.

And the I changed the mysql text field of the drop down field in CB into a decimal (10,1) field in mysql.

That works so far. Can you tell me whether this should be ok or do you see difficilties later on (search etc.)?

Oh, not enough clear described:

1 level = CB
2 level = mysql

In CB I have a drop down field, that create a text field in the mysql data bank in xxxx_comprofiler.
In mysql I change the field type from text to decimal (10,1)!

So in CB the drop down stores further in the mysql field, that works, in spite of my change from text to decimal in mysql.

So why I do this? By this I have the mysql field in the appropriate status, as the documentation of the export/import-php-tool need, to be compatible with other websites.

My question: do you see any problems here, that I don't see at the moment? May the search don't work then or something other will be problematic?

Thanks.