This content has been marked as final. Show 4 replies
Hello Marcus,1 person found this helpful
thanks for reporting the problem. I logged bug for wrong transformation of logical types to domain.
What am I supposed to enter when I define a NUMBER(5,2) or a NUMBER(10)? The label don't make sense to me.for NUMBER(5,2) you need to set precision=5 and scale=2, for NUMBER(10) you need only precision=10. scale=0 is ignored, otherwise scale could be negative or positive number.
for NUMBER(5,2) you need to set precision=5 and scale=2,that's what I would expect, but it seems that at least the label in the Domain Administration dialog are wrong, because I have to enter precision=2 and scale=5 to get a NUMBER(5,2).
but it seems that at least the label in the Domain Administration dialog are wronglabels for the left column are:
The first time I saw Windows in Bulgarian I was shocked and never tried it again.
If you can confirm that Precision and Scale are not named properly in German then I'll log a bug for that.
today I reopened the diagram I created yesterday and the wrong types created from the domains were still there, so I reversed the scale <-> precision entries and only NUMBER columns were displayed. I reversed them again and now scale 5, precision 2 give the correct NUMBER(5,2).
I hope noone expects me to understand this :-)