Forum Discussion

TimoRiikonen's avatar
TimoRiikonen
Icon for Advocate V rankAdvocate V
2 years ago
Solved

European letters not supported on column names on Notebook + Lakehouse combination

Hello,   SQL syntax has supported pretty well European, in this case Scandinavian, letters for the past 40 years. The SQL engine in Lakehouse works also well. I can query like this without issues...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi TimoRiikonen 

     

    For special characters, you can try the:

     

    `

     

     

    %%sql
SELECT `Päivitetty` 
FROM Query

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

TimoRiikonen's avatar
TimoRiikonen
Icon for Advocate V rankAdvocate V
2 years ago

Right!

I had tested [], "" and '', but the correct answer was ``.

This different syntax may confuse other people besides me, so you think of using the standard SQL syntax and [].

But this solves it for me, thank you.