About string

11-20 of 200Refresh
Forum
18

String Contains Query Result - Possible?

Hi, I have a managed database for an Entity, "Program", containing a String field, "description", that is effectively a unique sub-string of a system generated description. Example ... wildcards as the input string will be larger than the string being searched for. Presently
Issue
18

Enable intern() for Retrieved Strings

Implement a setting, where the developer can specify which Strings should be loaded via the String ... of instantiating every first name with a new String, the user should be able to specify that this field should be loaded via String.intern() (with all its advantages and disadvantages). mlaggner
Forum
18

substring works with string but not with char

with a string parameter select f from Foo f where substring(f.name, 1, 1) = ?1 but when i use a char ... is String and the type on the right side expression (the parameter) is Character. In ObjectDB as in Java char is comparable to int but not to String. Maybe an exception has to be thrown on attempt
Forum
18

String representation of a query

Hi, Is it possible to get a JPQL string having a Query object instance? JpaQuery class doesn't ... that information with JPQL string and parameters map to find and optimize the most ineffective cases. Following your request a toString implementation that returns the query string was added to queries. Thank you, works perfectly. kborkowski
Issue
18

@Enumerated(EnumType.STRING) annotation inhibits proper execution of IN expressions.

When the following annotation is present on an enum type entity field: @Enumerated(EnumType.STRING) Queries using JPQL IN expressions on this field won't work correctly anymore. This issue ... can be easily repeated by changing the example in forum post #1254 to @Enumerated(EnumType.STRING), as
Issue
18

Collation and String Order

ObjectDB should support selecting collation when a new database is created. The collation will affect the way strings are sorted in queries (with ORDER BY). Currently strings are always ordered by Unicode order, and a workaround that enables controlling the order is to use normalizing, as discussed
Forum
18

order by string with numbers

Hi Anyone could help me I need to order a string  for example user1, user2, ..., user1000 I found sql solution but I would like to use criteria builder and I don´t if exist CAST and AS UNSIGNED ... string queries. You may try using Integer.parseInt as a JPA criteria query function. mlevinspuhl
Forum
18

Schema migration - long to String

Hi, I need to change field type in our model from long to String. After changing filed type in our model and repairing database with doctor, most of our entities is gone. Doctor puts some errors ... ? Changing a field from long to String should not require any specific action. Actually such schema
Forum
18

like operator (String)

, alsothere exists an @Index for String email         Thank you for this report. You are right, LIKE
Forum
18

String comparison in query where clause

I am having trouble getting a simple string comparison to work in an SQL "where" clause.  It is my understanding that queries are case sensitive by default and I do not want that, so I am constructing the query as follows... SELECT e FROM Exercise AS e WHERE UPPER(e.name) = ?0 and then I