Hi Everybody. I have 2 similar tables, one in Oracle, and other in H2. I am ordering by PK, which are 2 fields Strings, but when i am ordering, the ordered query is different between H2 an Oracle. For example:
select * from table_name order by column_id(varchar32) asc in oracle the "letters" goes first, and H2 the "numbers" go first. For exemple, If i had 3 registers unordered in the same Table on Oracle and H2 like: bb1234. a124sb 1bbe42 In H2 the order will be: 1bbe42 a124sb bb1234 In Oracle the order will be: a124sb bb1234 1bbe42 My problem is that i was the same order in the 2 databases. Somebody knows how can I do it?? Thank you. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
