db icon indicating copy to clipboard operation
db copied to clipboard

Published 20 hours ago • verified publisher icon yiisoft

Get DB type without size

Open arogachev opened this issue 2 years ago • 4 comments

Related - #694.

arogachev avatar Apr 11 '23 15:04 arogachev

closed via #694

terabytesoftw avatar Apr 11 '23 18:04 terabytesoftw

This is a separate issue.

Example:

getDbType()- varchar(255). getSize() - 255. ??? - varchar.

arogachev avatar Apr 13 '23 05:04 arogachev

What is case when need type without size?

vjik avatar Apr 20 '23 08:04 vjik

In db-pgsql and db-oracle (almost all types) and db-mssql (some types) getDbType() returns type without size.

For DBMS consistence it is better to store pure db type (e.g. varchar) in ColumnSchema::$dbType. And have a method to generate the complete db type (e.g. varchar(255))

Tigrov avatar Aug 12 '23 15:08 Tigrov

Now getDbType() returns clear db type, for example varchar instead of varchar(255)

Tigrov avatar Nov 08 '24 01:11 Tigrov