× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Nilesh Mali
nileshhmali reported 2016-02-24T08:20:45Z  · tariqrahiman last modified 2016-02-25T15:31:35Z

Behavior of SET COLLATION commands.


Dev
Jenny Nishimura
JennyNishimura
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component DB - Excel
Version 17.0
Product: Aqua Data Studio
Version: 17.0.3-3
Build #: 48711
Build Date: 2016-Feb-23 10:25:15 AM
 
Operating Environment: Linux (3.19.0-15-generic, amd64) / UTF-8 / en / US / Oracle Corporation 1.8.0_40-b26
Memory: Max=704,643,072;  Total=415,236,096;  Free=286,333,008;  CPUs=8
 
Connect Ms-Excel with attached dataset(.xls)
Open Query analyzer and execute below SET COLLATION commands.
 
Observation-01
 
SET COLLATION  OFF
GO
 
select * from Sheet1 where name like 'a' order by name;
Go
 
ADS Excel O/P: H2 database O/P:
name 
------- 
a 
a 
a 
a		 NAME 
------- 
a 
 
 
Observation-02
 
SET COLLATION ENGLISH STRENGTH PRIMARY
GO
 
select * from Sheet1 where name like 'a' order by name;
Go
 
ADS Excel O/P: H2 database O/P:
name 
------- 
A 
A 
A 
A 
a 
a 
a 
a		 NAME 
------- 
À 
Ä 
 
A 
à 
ä 
â 
a 
 
Observation-03
 
SET COLLATION ENGLISH STRENGTH SECONDARY
GO
 
select * from Sheet1 where name like 'a' order by name;
Go
 
ADS Excel O/P: H2 database O/P:
name 
------- 
A 
A 
A 
A 
a 
a 
a 
a		 NAME 
------- 
A 
a 
 
 
Observation-04
 
SET COLLATION ENGLISH STRENGTH TERTIARY
GO
 
select * from Sheet1 where name like 'a' order by name;
Go
 
ADS Excel O/P: H2 database O/P:
name 
------- 
a 
a 
a 
a		 NAME 
------- 
a 
 
Observation-05
 
SET COLLATION ENGLISH STRENGTH IDENTICAL
GO
 
select * from Sheet1 where name like 'a' order by name;
Go
 
ADS Excel O/P: H2 database O/P:
name 
------- 
a 
a 
a 
a		 NAME 
------- 
a 
 
Please confirm expected behavior.
 
6 attachments
  •  
  •  
  • No shares
  •  
All Comments (2) Change History
Sort 

Issue #14289
Closed
Invalid
Resolved 2016-02-24T16:37:14Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017