BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

[BI 4.1 SP8] Big Query Ignore Case Sensitive


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
Jlizzul
Forum Member
Forum Member



Joined: 26 Feb 2008

Posts: 12



PostPosted: Tue Sep 10, 2019 7:45 am 
Post subject: [BI 4.1 SP8] Big Query Ignore Case Sensitive

Hi everyone,

We are testing the migration of teradata documents to BigQuery. (modification of connection)

We have problems with filters since Teradata is not case sensitive, while BigQuery is.

We found the "Ignore Case" parameter in BigQuery to set in End SQL, but it is only valid in legacy SQL, unfortunately we are in Standard SQL.

We thought about applying upper/lower on our string fields, but that won't solve the problem.

Anyone have any feedback or ideas about this subject?

Thanks for your help,

Julien
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0447 seconds using 17 queries. (SQL 0.0191 Parse 0.0009 Other 0.0247)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo