× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Nilesh Mali
nileshhmali reported Feb 24, 2016  · tariqrahiman last modified Feb 25, 2016

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 Change History (6)
Sort 
Nilesh Mali
nileshhmali   Feb 24, 2016
Field Old Value New Value
Type Bug Support
Nilesh Mali
nileshhmali   Feb 24, 2016
Field Old Value New Value
Dev Assignee Unassigned tariqrahiman (Tariq Rahiman)
QA Assignee Unassigned tariqrahiman (Tariq Rahiman)
Tariq Rahiman
tariqrahiman   Feb 24, 2016
Field Old Value New Value
Dev Assignee tariqrahiman (Tariq Rahiman) JennyNishimura (Jenny Nishimura)
Jenny Nishimura
JennyNishimura   Feb 24, 2016
Field Old Value New Value
Resolution Invalid
Resolved Date Feb 24, 2016 4:37 PM
Status New Resolved
Nilesh Mali
nileshhmali   Feb 25, 2016
Field Old Value New Value
Status Resolved Verified
Tariq Rahiman
tariqrahiman   Feb 25, 2016
Field Old Value New Value
Status Verified Closed

Issue #14289
Closed
Invalid
Resolved Feb 24, 2016
 
 
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