Internal Website Search

11-15 of 15 resultsRefresh


	substring works with string but not with char i want to select all entities whose name starts with a specific letter, i can use this query with a string parameter select f from Foo f where substring (f.name, 1, 1) = ?1 but when i use a char, the query does not return anything. i think it should also be possible to use char/Character types
	order by string with numbers The sql that works is ORDER BY CAST( SUBSTR (username FROM 4) AS UNSIGNED) ASC Using JPQL SELECT u FROM Users u ORDER BY SUBSTRING (u.username,4)*1 ASC If you have other alternative for JPA
	Partial Indexing I have a question about partial indexing. For example, a field of String type ttt, will be distinguished by the first 5 characters, then I can make a index of substr (ttt,1,5) in MySQL. With ObjectDB, how can I write the annotation for this purpose? TIA gzdillon Lai Yang Currently ObjectDB supports
	combined index not used a unique substring from the query plan XML, so specifying the index name should work. support Support ... ? If it is, then any unique substring from that query plan that doesn't depend on parameters should work
	com.objectdb.o.InternalException: null ParseException { String dateOfBirthStr = personalNumber. substring (0

substring works with string but not with char