varchar2 problem

[Beagle]

Hi, first time poster, just installed both SugarSuite 4.5 and 4.2

In testing 4.5, I found that when creating a custom text field, Sugar was trying to create a varchar2 field. This datatype doesn't exist in MySQL 5.1, and the only DBMS I know of that supports it is Oracle. I didn't find anything in the forums or in the bug tracker on this. In order to add the custom field, I had to edit the source to switch from varchar2 to varchar.

Does anyone have any information as to why varchar2 is being used? Does 4.5 intend to support Oracle DB, or does MySQL 6 intend to use varchar2 (I couldn't find information regarding that)? Any help would be appreciated.

Nice piece of software, btw

--Beagle

[gmarton]

Hi i submitted this as a bug, most likely affect s all mysql users.
http://www.sugarcrm.com/crm/?option=...d-44e653069496

varchar2 is used in oracle:
http://www.ss64.com/orasyntax/datatypes.html

i got around it by changing mssql to mysql in
/modules/DynamicFields/templates/Fields/TemplateField.php line 157 (4.5RC1)

function get_db_type(){

if($GLOBALS['db']->dbType=='mssql'){

return " varchar($this->max_size)";

}else{

return " varchar2($this->max_size)";

}

}