Support

  1. 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
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. # 1
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. # 2
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 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. # 4
hopinn Accepted Answer
Title should by "How to display table which contains an accent".
  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.

Request Support

Support is currently Offline

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.