like operator does not work with jconnect and VERSION_6 setting
This is a discussion on like operator does not work with jconnect and VERSION_6 setting within the Sybase forums, part of the Database Server Software category; --> Hello, we are accessing a 12.5 ASE with jConnect 5.5. To get wide table support (varchar with length > ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 03:40 PM
| ||||
| ||||
 like operator does not work with jconnect and VERSION_6 setting Hello, we are accessing a 12.5 ASE with jConnect 5.5. To get wide table support (varchar with length > 255), we set the connection property JCONNECT_VERSION to 6, as described in the jconnect documentation. Strangely, this seems to affect the 'like' operator - a query with 'like' doesn't find anything, whether or not the search string contains wildcards. Switching back to JCONNECT_VERSION: 5 restores the functionality. Has anyone here seen that problem already? Regards, -- Thomas Corte Thomas.Corte@knipp.de      |
|
04-08-2008, 03:41 PM
| ||||
| ||||
| Re: like operator does not work with jconnect and VERSION_6 setting Hi, Thomas Corte wrote: > Strangely, this seems to affect the 'like' operator - a query with > 'like' doesn't find anything, whether or not the search string contains > wildcards. Switching back to JCONNECT_VERSION: 5 restores the > functionality. In the meantime I found out that the problem actually seems to be located in statement parameter substitution... at least, it can be solved by setting LITERAL_PARAMS to true. Regards, -- Thomas Corte Thomas.Corte@knipp.de |
Linear Mode
