Re: sql type reported for enum

Поиск
Список
Период
Сортировка
От dmp
Тема Re: sql type reported for enum
Дата
Msg-id 55D521F0.60503@ttc-cmc.net
обсуждение исходный текст
Ответ на Re: sql type reported for enum  (rcohen@e1b.org)
Ответы Re: sql type reported for enum  (rcohen@e1b.org)
Список pgsql-jdbc
rcohen@e1b.org wrote:
> It breaks the jdbc meta-data; that is for an enum column
>
>          columnsResultSet./getInt/("DATA_TYPE")
>
> now returns Types.VARCHAR.
>
> This breaks some of my code;  it also breaks DBUnit's support for postgres.  Now
> I can code around this, but should the metadata be reporting that an enum column
> is of  type Types.VARCHAR? This seems like incorrect behavior.
>
> Yes, enums should probably be avoided, but that isn't an option for me
> right now.
>
> Ross

Seems an Enum is only a set of characters and the MySQL database does define it
as such. So how does DBUnit handle that databases enum types?


Name        Class            Type    Type Name
enum_type    java.lang.String    1    CHAR

danap.








В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: sql type reported for enum
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: best way to convert JSONB object from result