This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I created a simple domain model and then updated the Oracle data, which is giving me some issues with data types. Instead of a C# string being an Oracle varchar, the database table field is created as a clob. And then with other fields like char, when I try to update database from the designer I get an error that the char type cannot be handled correctly. I'm evaluating your product and love what I see so far, but this is a major issue and I need to get this to work with Oracle. Thanks. |
|
|
|
|
The string is created as a CLOB because there is no length validation on it. From that we assume that the string can be indefinitely large, which maps to CLOB instead of VARCHAR2(n). Select the property, go into the Properties box and set Validate Length to (say) '<= 80' (without the quotes). We will then create a VARCHAR2(80) in the database as desired. I will follow up on the char issue -- this should map to a CHAR(1) so I will see what is going on. |
|
|
|
