| Subject | RE: [IBO] Problem with parameters in query |
|---|---|
| Author | |
| Post date | 2017-09-01T06:12:15Z |
I just figured out, that the collating makes the difference. When I create the domain like
create domain dom_c50 as char varying (50)
character set iso8859_1^
it works.
When I use
create domain dom_c50 as char varying (50)
character set iso8859_1 collate de_de^
it does not, because the sqlsubtype changes to 1557.
So it has to do with collate de_de.
It is the same problem,no matter which collate you use. For example with en_uk sqlsubtype is 3093 and for en_us sqlsubtype is 3605 and that raises the exception too.
Kind regrads
Helmut