Search without special SQL characters

Asked

Viewed 48 times

0

I need to do a search with SELECT, but the title is not displayed, because some calls that are opened comes with special characters. Can someone help me?

I use this command to search in the bank:

SELECT id,titulo,data FROM gl_data WHERE status='2';

inserir a descrição da imagem aqui

Until then everything ok however, when I try to pull the table through the site, the characters are not displayed;

inserir a descrição da imagem aqui

sql

  • Click [Edit] and put the code, and the description of the problem (what you expected, and instead what happened) - then it’s easier for someone to help.

  • which bank used?

  • I’m using the Mariadb

  • I believe the problem is in the form you want to add to the WEB, because the banks normally return columns containing " - "e " ç ".

  • Yes, I believe the problem is in my SELECT, but I can’t find a solution

  • If the data is recorded correctly in the database, it will be displayed in the same way in the client. Surely there is some typo when displaying the title

  • Is it not the site system? It is a flash system. Then I add a table and in this table I put the command of the bank. Maybe it’s the table version of the site..

  • Look @ALANBERTOLDOOLIVEIRA so it is very difficult to help, try to exemplify the maximum and put all the code of this query/addition stream in the web layer. beauty?

  • I believe it is not a problem in the query but in the view of your site, posted the way you do.

Show 4 more comments

1 answer

0

Alan, I recommend you check the enconding being written to the database and the enconding the application is using.

You have to see how the Flash treats that question.

Hug.

Browser other questions tagged sql

You are not signed in. Login or sign up in order to post.