Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Friday 4:49 am
Add a reply View Replies (5)

Resolved How to display table which contains an accent

  1. hopinn
    hopinn
  2. Support
  3. Thursday, July 09 2015, 11:24 AM
Hello,

i'm using the syntax for showing menu, this works fine.

Custom SQL WHERE soort LIKE "%Restaurant%"

However if I want to show where the table contains Café i have an ACCENT problem. How do i fix this?

I tried

replace(replace(soort,'é','e')) LIKE COLLATE Latin1_general_CI_AI '%cafe%' COLLATE Latin1_general_CI_AI

OR

soort COLLATE Latin1_General_CI_AI Like "%cafe%" COLLATE Latin1_General_CI_AI

OR

oort LIKE '%cafe%' COLLATE Latin1_General_CI_AI

but all three of them did not work and showed no result, do you know the solution of this problem?

thank you,

marK
Responses (5)
hopinn
hopinn Accepted Answer
Title should by "How to display table which contains an accent".
  1. more than a month ago
  2. Support
  3. # 1
admin
admin Accepted Answer
Admin
Hi,
have you tried to use Mysql REGEX operator?

Title should by "How to display table which contains an accent".

I found this, maybe can help you: http://stackoverflow.com/questions/401771/how-can-i-find-non-ascii-characters-in-mysql
  1. more than a month ago
  2. Support
  3. # 2
hopinn
hopinn Accepted Answer
What would the syntax then be like?

i posted a pic with the syntax which is working fine when there aren't any accents

thank you

!!! Please change the title of question, thank you !!!

Title should by "How to display table which contains an accent".
  1. more than a month ago
  2. Support
  3. # 3
admin
admin Accepted Answer
Admin
Hi,
What would the syntax then be like?
Sorry I don't know, this is a something about SQL query not Easy Profile. we should do some tests to find a useful syntax (though that may be different depending on the character encoding used by the DB).


Anyway, I suppose that Café and Restaurant are option of Select/Radio/Checkbox field type, it's true? if yes you can write options like these:
cafe|Café
restaurant|Restaurant
.....

with this in db are stored cafe not Café, so operations on DB are more simple.
  1. more than a month ago
  2. Support
  3. # 4
hopinn
hopinn Accepted Answer
Hello,

in our DB they're stored as f.i. "Caf\\u00e9" but this cannot be used in the field WHERE because of the "\\"

i solved this with a little detour => i omitted the character with the accent =>

soort LIKE "%caf%"

which works in our case

thank you for your help,
  1. more than a month ago
  2. Support
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.