Data Studio
2.5K members online now
2.5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Using COLLATE In Datastudio

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

hello everyone, 

i have a little question about Mysql and Datastudio. In sql, if i have special characters (like lower case and upper case) i can use COLLATE utf8_bin to solve the problem. 

do you know if there is a similar solution in datastudio? 

ive seen that lower and upper case are taken together in many cases (eg. i used contains, regex match, etc)

can you please help?

thanks

eugenio

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Eugenio T
May

Using COLLATE In Datastudio

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

you can check the available functions here

 

https://support.google.com/datastudio/table/6379764?hl=en

 

there is upper and lower functions.

 

cheers

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Eugenio T
May

Using COLLATE In Datastudio

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

you can check the available functions here

 

https://support.google.com/datastudio/table/6379764?hl=en

 

there is upper and lower functions.

 

cheers

Using COLLATE In Datastudio

Follower ✭ ✭ ☆
# 3
Follower ✭ ✭ ☆

thanks Mimoune! Smiley Happy